TRUNCATE TABLE Name
Name
is the name of the table that you want to truncate or the name of the table for which you want to delete all rows.
TRUNCATE table is functionally the same as a DELETE statement without a WHERE clause: Both delete all rows in the table. However, TRUNCATE TABLE is faster than DELETE and uses less system and transaction log resources.
The DELETE statement deletes one row at a time and records an entry in the transaction log for each row that is deleted. TRUNCATE table deletes data by releasing the data pages used to store the table data, and only records the release of the page in the transaction log.
TRUNCATE table deletes all rows in the tables, but the table structure and its columns, constraints, indexes, and so on remain unchanged. The count value used for the new line identification is reset to the seed of the column. If you want to keep the identity count value, use DELETE instead. If you want to delete the table definition and its data, use the DROP table statement.
For tables referenced by the FOREIGN KEY constraint, you cannot use TRUNCATE table, but you should use a DELETE statement without a WHERE clause. Because the TRUNCATE TABLE is not logged in the log, it cannot activate the trigger.
TRUNCATE table cannot be used for tables that participate in indexed views.
Use the update STATISTICS to maintain index information when adding data to a table that deletes data with TRUNCATE table.
If there is a rollback statement, the delete operation is revoked, but the truncate is not revoked.
TRUNCATE TABLE name [Drop/reuse STORAGE]
DROP STORAGE: Explicitly indicates space to release data tables and indexes
Reuse STORAGE: Explicitly indicate space without releasing data tables and indexes
The truncate command will restore the field to start with 1, or you can try to empty the table_a, then cancel the increase, save, and then add back to the self, which is the way to restore the self-increasing segment to 1.
There are two other ways to restore the table ID to 1
1.delete from your table name
DBCC CHECKIDENT (your table name, reseed,0)
2. If you want to save your data, introduce your third method, by Qinyi
Export the database with phpMyAdmin, you'll find it in there!
Edit the SQL file, and then change the self to the next ID number, and then import it.