Following syntax can be used to check the current identity value of table:
USE DatabaseName; GO DBCC CHECKIDENT ("TableName", NORESEED); GO
Following syntax can be used to reset the current identity value of table:
USE DatabaseName; GO DBCC CHECKIDENT ("TableName", RESEED, 10); GO
No comments:
Post a Comment