/SQL/Cannot truncate a table referenced in a foreign key constraint

Cannot truncate a table referenced in a foreign key constraint

Cannot truncate a table referenced in a foreign key constraint

SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE table $table_name; 
SET FOREIGN_KEY_CHECKS = 1;

3

Source: stackoverflow.com

Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint

As the error says, you can not truncate tables referenced by foreign keys. 
Delete should work though...

DB::table('some_table')->delete();

0

How to force truncate a table in mysql

DELETE FROM mytest.instance;
ALTER TABLE mytest.instance AUTO_INCREMENT = 1;

0

Similar codes

0 vote207 views1 answer
Mysql update from n to 100
SQL
0 vote200 views1 answer
Drop all tables db2
SQL
0 vote201 views1 answer
Mysql coonect sample code
SQL
1 vote216 views1 answer
Mysql get max value and id
SQL
0 vote219 views1 answer
How to inner join 4 tables in sql
SQL
0 vote201 views1 answer
Mysql trim characters
SQL
0 vote191 views1 answer
Sql check for null and empty string
SQL
0 vote193 views1 answer
Select all tables linked server sql
SQL
1 vote220 views1 answer
Mysql how to truncate table with foreign keys
SQL
4 votes208 views1 answer
Oracle error line
SQL

Share