/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 vote147 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote137 views1 answer
In mysql workbench contnent not feching
SQL
0 vote157 views1 answer
Sql update subtract value
SQL
0 vote142 views1 answer
Access refused mysql xampp server
SQL
0 vote144 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote150 views1 answer
Postgres statistics
SQL
24 votes150 views5 answers
Sql server insert into select
SQL
0 vote192 views1 answer
Get first monday of month sql
SQL
0 vote145 views1 answer
Convert sql server guid to varbinary
SQL
16 votes145 views1 answer
Mysql reset auto increment value
SQL

Share