On this blog you will find general information & articles related to Microsoft .Net Programming and SQL Server tweeks. Please feel free to browse around the different articles and information of this blog. If you find any incorrect information in any of my papers or articles on this site, please let me know about it. I'll either make the necessary corrections or try to accommodate your comments and their resolutions in the paper.
Friday, October 30, 2015
Set Auto-Seed Column to 1 without using TRUNCATE command on a table which is referenced in another table
DELETEFROM dbo.masterTbl;DBCC CHECKIDENT ('dbo.masterTbl', RESEED,0)-- will set IDENTITY count back to 0
Alternatively, you can drop the existing relational constraints, use TRUNCATE command and recreate relational constraints.
No comments:
Post a Comment