Skip to content
This repository has been archived by the owner on Jan 3, 2022. It is now read-only.

SQL Dialect

Antonello Provenzano edited this page Mar 20, 2016 · 3 revisions

SQL Standard

Supported SQL Statements

Data Definition Language (DDL)

CREATE

CREATE SCHEMA

CREATE SCHEMA <schema_name>

CREATE TABLE

CREATE TABLE [IF NOT EXISTS] <table_name> ( [ <column_def | constraint_def> ]+ )

column_def ::= <column_name> <column_type> [ <column_constraint> ]* [ DEFAULT <expression> ] column_type ::= [SQL Type](SQL Types) column_constraint ::= NOT NULL | PRIMARY [KEY] | UNIQUE [KEY] | CHECK <expression> | IDENTITY constraint_def ::= <constraint_name> [ PRIMARY KEY ( [ <column_name> ]+ ) |

NOTE: If a column defines the IDENTITY constraint, specifying other constraints or a DEFAULT expression will result into an error

CREATE VIEW
CREATE TYPE
CREATE USER
CREATE TRIGGER
CREATE PROCEDURE
CREATE FUNCTION

ALTER

ALTER TABLE
ALTER USER
ALTER FUNCTION
ALTER PROCEDURE

DROP

DROP SCHEMA
DROP TABLE
DROP USER
DROP TYPE
DROP TRIGGER
DROP PROCEDURE
DROP FUNCTION

Data Manipulation Language (DML)

INSERT

SELECT

DELETE

UPDATE

SHOW

Data Control Labguage (DCL)

CREATE USER

DROP USER

ALTER USER

CREATE ROLE

DROP ROLE

GRANT

REVOKE

Transaction Control Language

COMMIT

ROLLBACK