/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

3 votes205 views2 answers
Mysql select database
SQL
0 vote184 views2 answers
Zsh: command not found: mysq
SQL
0 vote183 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote198 views1 answer
Savepoint mysql script
SQL
0 vote180 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
1 vote243 views1 answer
Oracle apex version view
SQL
0 vote219 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote185 views1 answer
Create or replace view postgress
SQL
0 vote281 views1 answer
Import sql dump into postgresql database
SQL
0 vote186 views1 answer
How to put value in parameters in mysqldataadapter
SQL

Share