redhat man page for truncate

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)

NAME
TRUNCATE - empty a table
SYNOPSIS
TRUNCATE [ 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.
DESCRIPTION
TRUNCATE 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.
USAGE
Truncate the table bigtable: TRUNCATE TABLE bigtable;
COMPATIBILITY
SQL92 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