TRUNCATE TABLE name TRUNCATE TABLE is functionally identical to DELETE statement with no WHERE clause: both remove all rows in the table. But TRUNCATE TABLE is faster and uses fewer system and transaction log resources than DELETE.
msdn.microsoft.com/en-us/library/aa260621(SQL.80).aspx
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. Compared to the DELETE statement, TRUNCATE TABLE has the following advantages:
msdn.microsoft.com/en-us/library/ms177570.aspx
This sql tutorial section introduces the keyword TRUNCATE TABLE. Truncate table is used to clean all data from a table. For this, we can use the TRUNCATE TABLE command. The syntax for TRUNCATE TABLE is...
www.1keydata.com/sql/sqltruncate.html www.1keydata.com/sql/sqltruncate.html
In applications, users need truncate privileges on third party tables. The owner of the table can truncate his/her own tables. A user with DBA role granted...
www.psoug.org/reference/truncate.html www.psoug.org/reference/truncate.html
TRUNCATE TABLE empties a table completely. Logically, this is equivalent to a DELETE statement that deletes all rows, but there are practical differences under some circumstances. For an InnoDB table before version 5.0.3, InnoDB processes TRUNCATE TABLE by deleting rows one by one. As of MySQL 5.0.3, row by row deletion...
dev.mysql.com/doc/refman/5.0/en/truncate.html dev.mysql.com/doc/refman/5.0/en/truncate.html
TRUNCATE TABLE empties a table completely. Logically, this is equivalent to a DELETE statement that deletes all rows, but there are practical differences...
dev.mysql.com/doc/refman/5.0/en/truncate-table.html dev.mysql.com/doc/refman/5.0/en/truncate-table.html
TRUNCATE TABLE empties a table completely. Logically, this is equivalent to a DELETE statement that deletes all rows, but there are practical differences under some circumstances. For InnoDB, TRUNCATE TABLE is mapped to DELETE, so there is no difference.
dev.mysql.com/doc/refman/4.1/en/truncate.html dev.mysql.com/doc/refman/4.1/en/truncate.html
create table blah ( acol int ) truncate table blah select COUNT(*) from blah drop table blah...
sqlblogcasts.com/blogs/tonyrogerson/archive/2009/09/05/... sqlblogcasts.com/blogs/tonyrogerson/archive/2009/09/05/truncate-table-transactional.aspx
This video tutorial will conclude with a final wrap up of the DELETE statement by including a discussion of the TRUNCATE TABLE statement, and the differences between the two statements. Highlights from this video: What does the TRUNCATE TABL - Course 150 What does the TRUNCATE TABLE statement do and syntax?
www.learntransactsql.com/VideoTutorials/TechnicalTraini... www.learntransactsql.com/VideoTutorials/TechnicalTrainingVideo1191.aspx
Use the TRUNCATE TABLE statement to remove all rows from a table. By default, Oracle Database also performs the following tasks: Removing rows with the TRUNCATE TABLE statement can be faster than removing all rows with the DELETE statement, especially if the table has numerous triggers, indexes, and other dependencies...
download.oracle.com/docs/cd/B28359_01/server.111/b28286... download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_10007.htm