Remove CONSTRAINT from exist table

Hello Guys,

Please help me out from this problem. How can I remove CONSTRAINT from exist data in Table. I am unable to delete that particular Column.

Thanks

  Kuldeep Singh

Hi Kuldeep,

If you want to delete constraint from a table. You have to check the constraint name by using below query.

Sp_help tablename.

Once you will get the constraints name you have to use below query-

Alter table table_name

Drop constraint constraint name.


Thanks,

  Devbrat Tripathi       08 Dec 2017       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any