Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
howto:reset_identity_column_value_in_sql_server [2011/11/23 20:23] – created 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 ===== | ||
+ | http:// |