skip to main content

Embedded SQL Statements : TRUNCATE TABLE
TRUNCATE TABLE
The TRUNCATE TABLE statement deletes all rows in a table.
General format
EXEC SQL [AT Database]
 
  TRUNCATE TABLE Table-Name [Options]
 
END-EXEC
Syntax rules
1.
Options is passed to the driver without further checks. Refer to the database documentation for detailed syntax. Syntax errors, if any, are returned at runtime.
2.
Table-Name is a User-defined word, as defined in the Definitions section of the Preface of this document.
Examples
Empty the table log
exec sql
     truncate table log
end-exec
Copyright (c) 2017 Veryant
Contact us
Please share your comments on this manual or on any
Veryant product documentation with the email button at the top left