Thursday, October 25, 2007

Truncate (SQL)
In SQL, the TRUNCATE statement removes all the data from a table. The TRUNCATE statement is not actually a part of the SQL standard, but many relational database management systems implement it. It is equivalent in function to a DELETE FROM my table; statement. However, on some systems, it is implemented differently.
The syntax for issuing a truncate command on a table could be implemented as: Truncate Table [schema][.] <table_name>;

No comments: