TRUNCATE TABLE
From Lianjapedia
Revision as of 06:53, 6 July 2015 by Yvonne.milne (Talk | contribs)
Contents
Purpose
Deletes all rows from a table
Syntax
TRUNCATE TABLE [<database>!]<table>
See Also
ADD TABLE, CLOSE, CREATE DATABASE, DECLARE CURSOR, DELETE, DROP CURSOR, EXECUTE IMMEDIATE, FETCH, GETENV(), INSERT, OPEN, OPEN DATABASE, SET AUTOCATALOG, UPDATE, USE, ZAP
Description
The TRUNCATE TABLE command executes an immediate physical deletion of all the records in the table i.e., records are permanently removed from the table, and cannot be recalled.
It is the equivalent of the NoSQL ZAP command.
Introduced in Lianja v2.0.
Keywords | Description |
---|---|
database | The name of the database to which the table belongs. The '!' character must be included between the database name and the table name. |
table | The name of the table from which to delete the rows. |
Example
truncate table southwind!temp