Explanation of Truncate Table usage

TRUNCATE TABLE

Deletes all rows in a table without logging individual row deletions.

grammar

TRUNCATE TABLE name

parameter

name

Is the name of the table to be truncated or from which all rows are to be deleted.

Notes

TRUNCATE TABLE is functionally identical to a DELETE statement without a WHERE clause: both delete all rows in the table. However, TRUNCATE TABLE is faster than DELETE and uses fewer 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 deleted. TRUNCATE TABLE deletes data by freeing the data pages used to store table data, and only records the release of pages in the transaction log.

TRUNCATE TABLE deletes all rows in the table, but the table structure and its columns, constraints, indexes, etc. remain unchanged. The count value used to identify new rows is reset to the seed for the column. If you want to preserve the identity count value, use DELETE instead. If you want to remove a table definition and its data, use the DROP TABLE statement.

For tables referenced by a FOREIGN KEY constraint, TRUNCATE TABLE cannot be used. Instead, a DELETE statement without a WHERE clause should be used. Because TRUNCATE TABLE is not logged, it cannot activate triggers.

TRUNCATE TABLE cannot be used on a table that participates in an indexed view.

Example

The following example deletes all data from the authors table.

TRUNCATE TABLE authors

Permissions

TRUNCATE TABLE permissions default to the table owner, members of sysadmin fixed server role, and members of db_owner and db_ddladmin fixed database roles and are not transferable.

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links