/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

2 votes353 views1 answer
Oracle list duplicates
SQL
0 vote326 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote306 views2 answers
Avg() sql
SQL
1 vote368 views1 answer
Nullif postgresql
SQL
0 vote317 views1 answer
Order by number of character in sql
SQL
93 votes451 views4 answers
Create database postgres
SQL
4 votes325 views1 answer
Restart for pg_hba.conf file
SQL
0 vote392 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
3 votes322 views2 answers
Sql random integer
SQL
16 votes409 views2 answers
Sql vs nosql
SQL

Share