How to realize automatic growth and zeroing in SQL Server

This article is about how to achieve automatic growth zero clearance in SQL Server, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. Let's take a look at it with the editor.

Method 1: the code is as follows:

Truncate table TableName

When you delete all the data in the table, it will automatically grow and clear zero. If a foreign key references this table, this method will report an error (even if both 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 clear zero oh. Method 2: copy the code as follows: DBCC CHECKIDENT ('TableName', RESEED, 0)

Do not delete the data of the table, directly reset the automatically growing value.

The above is how to achieve automatic growth zero clearance in SQL Server, the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.