/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

1 vote135 views1 answer
Customer using hdfc bank sql query
SQL
1 vote256 views1 answer
Postgres upgrade to superuser
SQL
0 vote110 views1 answer
Set engine to innodb
SQL
0 vote150 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote116 views1 answer
Mysql autoincrement valor inicial
SQL
18 votes112 views3 answers
Mysql add column default value
SQL
1 vote126 views1 answer
Moodle query first user access
SQL
2 votes116 views1 answer
Oracle kill session by sql_id
SQL
1 vote118 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
9 votes111 views3 answers
Mysql get last id
SQL

Share