Answers for "query to delete the constraints of table"

SQL
1

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;
Posted by: Guest on February-19-2021
0

uncheck constraints and delete from table

alter table MyOtherTable nocheck constraint all
delete from MyTable
alter table MyOtherTable check constraint all
Posted by: Guest on June-02-2021

Code answers related to "query to delete the constraints of table"

Code answers related to "SQL"

Browse Popular Code Answers by Language