SELECT IDENT_CURRENT('TestTable') IdentityInTable -- shows current identity
Now execute the DBCC CHECKIDENT command to reset the Seed value for the table as
DBCC CHECKIDENT('TestTable', RESEED, 33)—reset identity
check the current Identity Value.
SELECT IDENT_CURRENT('TestTable') IdentityInTable
No comments:
Post a Comment