Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
howto:reset_identity_column_value_in_sql_server [2011/11/23 20:24] – smark | howto:reset_identity_column_value_in_sql_server [2011/12/19 21:15] (current) – smark | ||
---|---|---|---|
Line 12: | Line 12: | ||
This means that the number you input in place of ' | This means that the number you input in place of ' | ||
+ | |||
+ | To reset a table: | ||
+ | < | ||
+ | DBCC CHECKIDENT (tablename, RESEED, 0) | ||
+ | </ | ||
===== Sources ===== | ===== Sources ===== | ||
http:// | http:// |