DBCC CHECKIDENT - Check and/or reseed the current identity value for a table.

Syntax
      DBCC CHECKIDENT 
( 'table'
[ , { NORESEED | { RESEED [ , new_reseed_value ] } } ]
) [WITH NO_INFOMSGS] Key: NORESEED - The current identity value should not be changed. RESEED - Change the identity value. new_reseed_value - The new seed value to be used for the identity column. WITH NO_INFOMSGS - Suppresses all information messages.

Example

-- Reset the current identity value
USE MyDatabase;
GO
DBCC CHECKIDENT ('MySchema.MyTable', RESEED, 5000);
GO

I finally got it all together and now I forgot where I put it! ~ anon

Related commands

DBCC CHECKCONSTRAINTS - Check integrity of table constraints.

Equivalent Oracle command:

SELECT Sequence_for_my_Table.currval into CurrIdentity from dual;


© Copyright SS64.com 1999-2014
Some rights reserved