LucidDbSqlReference

LucidDB follows the SQL:2003 standard very closely, so in most cases there's nothing new to learn in order to execute SQL statements. The pages below cover the details of each statement, including any extensions to the standard. (See LucidDbSqlConformance for more.)

Reserved Words

LucidDB's parser has a list of reserved words which must be double-quoted when used as identifiers.

Queries

• Query statement
• SELECT expression
• Explicit TABLE expression
• Explicit VALUES expression

DML Statements

• CALL
• DELETE
• INSERT
• MERGE (upsert)
• UPDATE

DDL Statements: CREATE

• CREATE FOREIGN TABLE
• CREATE FOREIGN WRAPPER
• CREATE FUNCTION
  • CREATE FUNCTION (SQL UDF)
  • CREATE FUNCTION (Java UDF)
  • CREATE FUNCTION (Java UDX)
• CREATE INDEX
• CREATE JAR
• CREATE LABEL
• CREATE PROCEDURE
• CREATE ROLE
• CREATE SCHEMA
• CREATE SERVER
• CREATE TABLE
• CREATE USER
• CREATE VIEW

DDL Statements: DROP

• DROP FOREIGN TABLE
• DROP FOREIGN WRAPPER
• DROP FUNCTION
• DROP INDEX
• DROP JAR
• DROP LABEL
• DROP PROCEDURE
• DROP ROLE
• DROP SCHEMA
• DROP SERVER
• DROP TABLE
• DROP USER
• DROP VIEW

Miscellaneous Statements

• ALTER SESSION
• ALTER SYSTEM
• ALTER TABLE ADD COLUMN
• ALTER TABLE ALTER COLUMN
• ALTER TABLE REBUILD
• ANALYZE TABLE
• EXPLAIN PLAN
• GRANT
• IMPORT FOREIGN SCHEMA
• SET CATALOG
• SET PATH
• SET SCHEMA
• TRUNCATE

Common Elements

• Data types
• Value expressions and predicates
• Primary keys and unique constraints