Loading

How To Get Constarint using select query

Mai Hu Na

14y2.2kSQL

hi all
select sql query to find default contraint on particular table for checking is constrint on particular table prasent or not.
plz help..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shankar M14y ago
Accepted answer
Hi Atul,

This gets you what you are expecting..

select * from sys.default_constraints;

Thanks,
Shankar
Mai Hu Na14y ago
thanks shankar but i need to check default constraint on table in sql so will possible select query with default constraint?
Shankar M14y ago
Hi Atul,

You can use sp_help command to get the Data Dictionary for the Tables.

Something like this,

sp_help EMP;

Here EMP is the Table Name.

Thanks,
Shankar