Thursday, August 22, 2013

How to Check Identity Value

DBCC CHECKIDENT
 (
    table_name
        [, { NORESEED | { RESEED [, new_reseed_value ] } } ]
)

DBCC CHECKIDENT (table)
DBCC CHECKIDENT (table, NORESEED)
DBCC CHECKIDENT (table, RESEED, 10)

No comments:

Post a Comment