/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

27 votes160 views5 answers
Mysql set password for user
SQL
0 vote158 views1 answer
How to change the field size of an existing column
SQL
0 vote142 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
1 vote115 views2 answers
DROP TABLes regardless of constraints
SQL
2 votes130 views1 answer
Oracle sql merge
SQL
2 votes180 views1 answer
Oracle trace session
SQL
0 vote156 views3 answers
Classement rang mysql 7
SQL
0 vote121 views1 answer
Oracle list subpartitions
SQL
6 votes115 views5 answers
Get current date sql
SQL
0 vote140 views1 answer
T-SQL Create Trigger
SQL

Share