Answers for "how to truncate table with foreign key constraint in sql server"

SQL
0

how to truncate table with foreign key constraint

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table1;
Posted by: Guest on October-01-2020
0

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 "how to truncate table with foreign key constraint in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language