How To Get Constarint using select query

Question

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

Shankar M · Answer

Hi Atul This gets you what you are expecting.. select * from sys.default_constraints; Thanks Shankar

Mai Hu Na · Answer

thanks shankar but i need to check default constraint on table in sql so will possible select query with default constraint?

Shankar M · Answer

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