/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 vote372 views1 answer
Pgsql is not permitted to log in
SQL
21 votes390 views5 answers
Oracle all tables
SQL
0 vote367 views1 answer
Mysql server not starting in xampp in mac
SQL
-1 vote339 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
3 votes385 views1 answer
Oracle list privileges
SQL
0 vote350 views1 answer
Postgresql select fast check no rows
SQL
0 vote349 views1 answer
Sql insert tuple
SQL
0 vote380 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
1 vote342 views1 answer
Oracle rolling back transactions
SQL
0 vote335 views6 answers
Unique key in sql
SQL

Share