/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

10 votes350 views1 answer
Oracle all_dependencies
SQL
0 vote382 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote345 views1 answer
Sql database connectivity
SQL
0 vote330 views1 answer
Postgresql copy backup table
SQL
0 vote384 views1 answer
Show specific events on mysql
SQL
0 vote305 views1 answer
Kannst du deine finger trainieren
SQL
0 vote344 views1 answer
Optimize sql query
SQL
0 vote365 views1 answer
Stored function in sql
SQL
2 votes348 views1 answer
Check isolation level in mysql
SQL
2 votes389 views2 answers
Postgres change owner of schema
SQL

Share