Difference between revisions of "TRUNCATE TABLE"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Barrymavin (Talk | contribs) (→Description) |
||
| Line 11: | Line 11: | ||
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. | 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. | + | It is the equivalent of the NoSQL [[ZAP]] command but differs in that the table does not need to be already open, so it can be used from ODBC connections to a Lianja server. |
Introduced in Lianja v2.0. | Introduced in Lianja v2.0. | ||
Latest revision as of 21:42, 25 December 2020
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 but differs in that the table does not need to be already open, so it can be used from ODBC connections to a Lianja server.
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
