Friday, August 27, 2010

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:

Post a Comment