Statement Reference

• ALTER TABLE
• CALL
• COMMIT
• CREATE CATALOG
• CREATE FUNCTION
• CREATE INDEX
• CREATE PROCEDURE
• CREATE SCHEMA
• CREATE TABLE
• CREATE TRIGGER
• CREATE VIEW
• DELETE
• DROP CATALOG
• DROP INDEX
• DROP ROUTINE
• DROP SCHEMA
• DROP TABLE
• DROP TEXTSEARCH
• DROP TRIGGER
• DROP VIEW
• GRANT
• INSERT
• RENAME TABLE
• REVOKE
• ROLLBACK
• SELECT
• SET User Variable
• SET SCHEMA
• SET TEMPLATE_PARAMETER
• SET TEXTSEARCH
• SET TRANSACTION
• START TRANSACTION
• TRUNCATE TABLE
• UPDATE

Usage

• Words in all caps and bold, indicate keywords. eg. TABLE
• User variables are indicated by itialic words. eg. TableName
• () indicates grouping. eg. ( ColumnName DataType ( ColumnConstraints | TableConstraint ) )
• | indicates a choice from multiple options. eg. ( CASCADE | RESTRICT )
• [] indicates that the block is optional. eg. [ CASCADE | RESTRICT ]
• ()* indicates that the group can be repeated n times separated by commas, where n starts from 0.
• ()+ indicates that the group can be repeated n times separated by commas, where n starts from 1.
• "" indicates words within double quotes are to be used as it is, even if they are not keywords.