/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

7 votes124 views3 answers
Python and mysql connectivity
SQL
0 vote140 views1 answer
Offset in postgresql example
SQL
1 vote133 views1 answer
Check current sequence value postgres
SQL
0 vote109 views1 answer
Sql character index
SQL
0 vote128 views1 answer
EnvironmentError: mysql_config not found
SQL
1 vote113 views4 answers
Get week day from date in sql
SQL
0 vote117 views1 answer
Connexion mysql
SQL
3 votes122 views1 answer
Get all elements sql
SQL
0 vote165 views1 answer
Get last inserted primary key
SQL
5 votes126 views1 answer
Oracle nls instance
SQL

Share