Monday, October 20, 2008

Delete Records and Reset Identity

Truncate table table_name (we use it when the table has no references)

(or)

delete from table_name
DBCC CHECKIDENT (table_name, RESEED, 0)

(we use it when the table is mapped with other table)

No comments: