SQL-TRUNCATE、DELETE、DROP的区别

2014-11-23 17:45:16 · 作者: · 浏览: 71

TRUNCATE: Removes all rows from a table without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.

DELETE: Removes one or more rows from a table or view in SQL Server.

DROP: Removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those tables.