/SQL/Drop table with constraints

Drop table with 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 vote148 views1 answer
Mysqli last row
SQL
0 vote140 views1 answer
Custom row number
SQL
3 votes126 views1 answer
Select without null values sql
SQL
0 vote135 views1 answer
Amount of entries in a table psql
SQL
1 vote127 views1 answer
Group_concat max length mysql
SQL
0 vote132 views1 answer
Oracle SQL join three tables and group by column
SQL
3 votes135 views1 answer
Pl sql escape &
SQL
0 vote149 views1 answer
How to retrive the today date sql
SQL
0 vote82 views1 answer
Oracle sql developer script output limit
SQL
1 vote142 views1 answer
Mysql query bulk insert
SQL

Share