Header Ads

How to truncate table which is being referenced by a FOREIGN KEY constraint?

DELETE FROM [table name];
DBCC CHECKIDENT([table name],RESEED,0);

No comments:

Powered by Blogger.