I have a table in my db that has an identity column as the primary key. I have deleted all the data and have tried to use truncate table on it to reset the identity column. The table has a number of foreign key constraints so it will not truncate.
Is there any way to reset the indentity column without removing the constraints?
Hi Jack,
You can reset the seed of the identity using DBCC CHECKIDENT.
See this link for more info:
Resetting IDENTITY
No comments:
Post a Comment