sql truncate table with foreign key 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)