Answers for "truncate on table with foreign key"

how to truncate table with foreign key constraint

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table1;

Posted by: Guest on October-01-2020

how to truncate foreign key constraint table

DELETE FROM [TableName]
DBCC CHECKIDENT ([TableName], RESEED, 0)

Posted by: Guest on June-06-2021

Code answers related to "truncate on table with foreign key"