SQL Server Returns the auto-growth column to zero

After a project is completed, there will be a lot of useless test data in the database. You can use Delete * to delete all the data, but the base of the Self-increasing column (usually the primary key) will not be zero, you can use the truncate function to delete all the data in the table and return the base number of the auto-increment column to zero. Note that all the data in the table is deleted. Its syntax is as follows:

 

Truncate   Table Tablename -- The data to be operated in tablename