/SQL/DROP TABLes regardless of constraints

DROP TABLes regardless of constraints

DROP TABLes regardless of constraints

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE <table_name>

-- if you want to later add or modify foreign keys
SET FOREIGN_KEY_CHECKS = 1;

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;

0

Similar codes

0 vote246 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
3 votes305 views2 answers
Oracle drop sequence
SQL
1 vote221 views1 answer
Ms sql how to see active job current run time
SQL
0 vote254 views1 answer
Mysqldump don't drop table
SQL
1 vote265 views1 answer
Insert column after column mysql
SQL
26 votes211 views10 answers
Insert in to table sql
SQL
10 votes287 views2 answers
Tsql merge example
SQL
0 vote264 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote264 views1 answer
Creation d'un trigger sql
SQL
0 vote270 views1 answer
Copy data from cell to cell mysql
SQL

Share