Query: truncate
OS: redhat
Section: 7
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
TRUNCATE(7) SQL Commands TRUNCATE(7)NAMETRUNCATE - empty a tableSYNOPSISTRUNCATE [ TABLE ] name INPUTS name The name (optionally schema-qualified) of the table to be truncated. OUTPUTS TRUNCATE TABLE Message returned if the table is successfully truncated.DESCRIPTIONTRUNCATE quickly removes all rows from a table. It has the same effect as an unqualified DELETE but since it does not actually scan the ta- ble it is faster. This is most useful on large tables. TRUNCATE cannot be executed inside a transaction block (BEGIN/COMMIT pair), because there is no way to roll it back.USAGETruncate the table bigtable: TRUNCATE TABLE bigtable;COMPATIBILITYSQL92 There is no TRUNCATE in SQL92. SQL - Language Statements 2002-11-22 TRUNCATE(7)
Related Man Pages |
---|
ndb_delete_all(1) - linux |
truncate(7) - centos |
ftruncate(2) - bsd |
drop_table(7) - debian |
drop_table(7) - linux |
Similar Topics in the Unix Linux Community |
---|
How can i truncate filenmes? |
Truncate multiple file extensions |
how to run cron job to truncate database table |
"Processes" truncated on Solaris |
Truncate file name to 40 characters |