/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 votes206 views3 answers
Convert ansi sql
SQL
0 vote206 views1 answer
Connect by query in oracle
SQL
15 votes208 views4 answers
Sql update from select
SQL
0 vote231 views1 answer
Consecutive numbers sql
SQL
2 votes227 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote202 views1 answer
Sql server remove primary key without dropping table
SQL
1 vote207 views2 answers
List tables sqlalchemy
SQL
5 votes210 views2 answers
Sql server port number
SQL
0 vote209 views1 answer
Sql on-premises
SQL
0 vote206 views1 answer
How to reset table in sql server
SQL

Share