can a table be truncating with foreign key constraints code example
Example 1: how to truncate table with foreign key constraint
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table1;
Example 2: how to truncate foreign key constraint table
DELETE FROM [TableName]
DBCC CHECKIDENT ([TableName], RESEED, 0)