Delete all rows in the table, but keep the table structure and its columns, constraints, indexes unchanged. truncate table [Table name]

Source: Internet
Author: User

 

Original post address: http://hi.baidu.com/liyanlin84/blog/item/eb306616cdb51e1c972b4389.html

Delete all data in the table, and you want to automatically increase the column from 1! Use truncate table tblname

 

Truncate is a SQL statement used to delete data table content. It is used as follows:Truncate table [Table name].
The following describes the methods and principles of the truncate statement in mssqlserver2000:
The truncate table name is fast and efficient because:
The truncate table function is the same as the delete statement without the 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 a row at a time and records one row in the transaction log. Truncate table deletes data by releasing the data pages used to store table data, and only records the release of pages in transaction logs.
Truncate table deletes all rows in the table, but the table structure, its columns, constraints, and indexes remain unchanged. The Count value used by the new row ID is reset to the seed of the column. To retain the ID Count value, use Delete instead. To delete table definitions and data, use the drop TABLE statement.
For tables referenced by the foreign key constraint, the truncate table cannot be used, but the delete statement without the WHERE clause should be used. Because the truncate table is not recorded in the log, it cannot activate the trigger.
The truncate table cannot be used in the index view.

Technorati label: sqlserver

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.