Documentation > USER GUIDE > SQL Manual

SQL Manual

Schema Commands


CREATE SCHEMA	COMMENT ON SCHEMA	ALTER SCHEMA	DROP SCHEMA
SELECT CURRENT_SCHEMA	SET SCHEMA

Data Definition


CREATE SEQUENCE	COMMENT ON SEQUENCE	ALTER SEQUENCE	DROP SEQUENCE

CREATE TABLE	COMMENT ON TABLE	COMMENT ON COLUMN	DROP TABLE
CREATE TABLE AS	ALTER TABLE ADD COLUMN	ALTER TABLE ALTER COLUMN	ALTER TABLE DROP COLUMN
CREATE TEMPORARY TABLE	ALTER TABLE ADD CONSTRAINT		ALTER TABLE DROP CONSTRAINT
	ALTER TABLE RENAME TO	ALTER TABLE RENAME COLUMN	ALTER TABLE SET SCHEMA
	ALTER TABLE SET INSERT ONLY	ALTER TABLE SET READ ONLY	ALTER TABLE SET READ WRITE

CREATE MERGE TABLE	ALTER TABLE ADD TABLE	ALTER TABLE SET TABLE	ALTER TABLE DROP TABLE
CREATE REMOTE TABLE
CREATE REPLICA TABLE
CREATE UNLOGGED TABLE
CREATE TABLE FROM LOADER

CREATE INDEX	COMMENT ON INDEX	DROP INDEX
CREATE IMPRINTS INDEX
CREATE ORDERED INDEX

CREATE TRIGGER	DROP TRIGGER

CREATE VIEW	COMMENT ON VIEW	DROP VIEW

CREATE FUNCTION	COMMENT ON FUNCTION	DROP FUNCTION	DROP ALL FUNCTION
CREATE FUNCTION EXTERNAL
CREATE FUNCTION LANGUAGE

CREATE PROCEDURE	COMMENT ON PROCEDURE	DROP PROCEDURE	DROP ALL PROCEDURE
CREATE PROCEDURE EXTERNAL

CREATE AGGREGATE	COMMENT ON AGGREGATE	DROP AGGREGATE	DROP ALL AGGREGATE
CREATE AGGREGATE EXTERNAL

CREATE FILTER FUNCTION	COMMENT ON FILTER FUNCTION	DROP FILTER FUNCTION	DROP ALL FILTER FUNCTION

CREATE LOADER	COMMENT ON LOADER	DROP LOADER	DROP ALL LOADER

CREATE WINDOW EXTERNAL	COMMENT ON WINDOW	DROP WINDOW	DROP ALL WINDOW

CREATE TYPE EXTERNAL	DROP TYPE

DECLARE var	SET var

Data Manipulation


SELECT	SELECT INTO	WITH SELECT

INSERT VALUES	INSERT SELECT
UPDATE	MERGE
DELETE	TRUNCATE

PREPARE	EXECUTE	DEALLOCATE

CALL procedure

SET SCHEMA	SET CURRENT_TIMEZONE	SET TIME ZONE

Data Import/Export


COPY INTO FROM	COPY INTO FROM STDIN	COPY BINARY INTO FROM	COPY LOADER INTO FROM
COPY INTO	COPY INTO STDOUT

Authorization & Data Access Control


CREATE USER	ALTER USER	DROP USER
SET USER	SET CURRENT_USER	SET SESSION_USER	SET SESSION AUTHORIZATION
GRANT PRIVILEGES	REVOKE PRIVILEGES
CREATE ROLE	SET ROLE	SET CURRENT_ROLE	DROP ROLE
GRANT ROLE	REVOKE ROLE

Transaction Management


START TRANSACTION	COMMIT	ROLLBACK
SET TRANSACTION	SET LOCAL TRANSACTION
SAVEPOINT	RELEASE SAVEPOINT	ROLLBACK TO SAVEPOINT

Development Commands


EXPLAIN	PLAN	TRACE
ANALYZE	SET OPTIMIZER

Pseudo Columns


CURRENT_SCHEMA
CURRENT_USER	USER	SESSION_USER	CURRENT_ROLE
CURRENT_DATE	CURRENT_TIME	CURRENT_TIMESTAMP	CURRENT_TIMEZONE
LOCALTIME	LOCALTIMESTAMP	NOW
NEXT VALUE FOR