tech.notes
for remembering things ...
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)
Older Posts
Home
Subscribe to:
Posts (Atom)