Answers for "drop table with constraints sql server"

drop table with constraints

1. 'First Drop contrstraints like this'
ALTER TABLE table_name
DROP CONSTRAINT constraint_name;
2. 'Then drop table'
DROP TABLE table_name;

drop df constraint sql server

ALTER TABLE NameTable	DROP CONSTRAINT Name_Constraint;
-- Example
--ALTER TABLE iso.works	DROP CONSTRAINT DF__works__idSubMont__4D5F7D71;