Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages

RedHat 9 (Linux i386) - man page for truncate (redhat section 7)

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 table 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)


All times are GMT -4. The time now is 08:59 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password