/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

18 votes113 views3 answers
Get the list of all tables in sql server
SQL
3 votes102 views1 answer
Sql select all
SQL
0 vote110 views1 answer
Sql server count all tables rows
SQL
0 vote109 views1 answer
Zsh: command not found: mysql mamp
SQL
8 votes97 views1 answer
Ltrim sql
SQL
6 votes116 views2 answers
Mysql 1 day ago
SQL
1 vote108 views1 answer
Mysql find tables with column name
SQL
0 vote121 views2 answers
Drop tables from local table database postgres
SQL
0 vote104 views1 answer
Print orcale
SQL
4 votes113 views2 answers
Sqlalchemy_database_uri for mysql
SQL

Share