/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 vote386 views1 answer
Sql alter column name sql server
SQL
2 votes363 views1 answer
Guid to string sql
SQL
0 vote354 views1 answer
Duplicate value unique constraint mysql error
SQL
2 votes352 views1 answer
Sql server find table name
SQL
2 votes430 views1 answer
Install postgresql centos 5
SQL
5 votes358 views1 answer
Sql select ciunt
SQL
1 vote427 views1 answer
Default
SQL
0 vote375 views1 answer
Creating h2 database in relative directory eclopse
SQL
2 votes371 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote313 views1 answer
Mysql convert column to uppercase
SQL

Share