Showing posts with label sql server. Show all posts
Showing posts with label sql server. Show all posts

11.19.2012

Cannot truncate table because it is being referenced by a FOREIGN KEY

This would have the same effect as truncate, minus the warning...(be careful, this also deletes all the data of the table referencing this table)
DELETE FROM dbo.Creators DBCC CHECKIDENT ('dbo.Creators',RESEED, 0)