/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 vote268 views2 answers
Influxdb delete measurement based on date
SQL
0 vote351 views1 answer
Python dictionary to sql update
SQL
0 vote310 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote336 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote298 views1 answer
How to use query in nosql
SQL
20 votes289 views5 answers
Mysql reset auto increment to 1
SQL
4 votes317 views2 answers
Installing sql on ubuntu
SQL
3 votes303 views1 answer
Oracle list invalid password ORA-01017
SQL
1 vote285 views2 answers
How to drop a unique constraint in sql
SQL
7 votes292 views2 answers
N highest salary in sql
SQL

Share