Answers for "sqlstate[42000]: syntax error or access violation: 1701 cannot truncate a table referenced in a foreign key constraint (`scraping`.`watches users`, constraint `watches_users_watch_id_foreign`) (sql: truncate table `watches`)"

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();

Posted by: Guest on November-30-2020

Code answers related to "sqlstate[42000]: syntax error or access violation: 1701 cannot truncate a table referenced in a foreign key constraint (`scraping`.`watches users`, constraint `watches_users_watch_id_foreign`) (sql: truncate table `watches`)"