LucidDbSqlReference

From Eigenpedia

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.)

Contents 1 Queries 2 DML Statements 3 DDL Statements: CREATE 4 DDL Statements: DROP 5 Miscellaneous Statements 6 Common Elements

Queries

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

DML Statements

• CALL
• DELETE
• INSERT
• MERGE (upsert)
• TRUNCATE
• Use MERGE to achieve 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 REBUILD
• ANALYZE TABLE
• EXPLAIN PLAN
• GRANT
• IMPORT FOREIGN SCHEMA
• SET CATALOG
• SET PATH
• SET SCHEMA

Common Elements

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