SQL Server automatic growth and resetting

Method 1:
Copy codeThe Code is as follows:
Truncate table TableName

When you delete all the data in the table, it is automatically increased and cleared.

If there is a foreign key to refer to this table, this method will report an error (even if the primary key table and the foreign key table have no data), please refer to method 2.

PS: Use delete to delete data. Automatic growth will not be cleared.

Method 2:
Copy codeThe Code is as follows:
Dbcc checkident ('tablename', RESEED, 0)

If you do not delete table data, you can reset the Automatically increasing value directly.