SQL语法

表 1 SQL语法格式说明

格式	意义
[ ]	表示用“[ ]”括起来的部分是可选的。
...	表示前面的元素可重复出现。
[ x | y | ... ]	表示从两个或多个选项中选取一个或者不选。
{ x | y | ... }	表示从两个或多个选项中选取一个。
[x | y | ... ] [ ... ]	表示可选多个参数或者不选，如果选择多个参数，则参数之间用空格分隔。
[ x | y | ... ] [ ,... ]	表示可选多个参数或者不选，如果选择多个参数，则参数之间用逗号分隔。
{ x | y | ... } [ ... ]	表示可选多个参数，至少选一个，如果选择多个参数，则参数之间以空格分隔。
{ x | y | ... } [ ,... ]	表示可选多个参数，至少选一个，如果选择多个参数，则参数之间用逗号分隔。

• ABORT
• ALTER AGGREGATE
• ALTER AUDIT POLICY
• ALTER DATABASE
• ALTER DATA SOURCE
• ALTER DEFAULT PRIVILEGES
• ALTER DIRECTORY
• ALTER EVENT
• ALTER EVENT TRIGGER
• ALTER EXTENSION
• ALTER FOREIGN DATA WRAPPER
• ALTER FOREIGN TABLE
• ALTER FUNCTION
• ALTER GLOBAL CONFIGURATION
• ALTER GROUP
• ALTER INDEX
• ALTER LANGUAGE
• ALTER LARGE OBJECT
• ALTER MASKING POLICY
• ALTER MATERIALIZED VIEW
• ALTER OPERATOR
• ALTER PACKAGE
• ALTER PROCEDURE
• ALTER PUBLICATION
• ALTER RESOURCE LABEL
• ALTER RESOURCE POOL
• ALTER ROLE
• ALTER ROW LEVEL SECURITY POLICY
• ALTER RULE
• ALTER SCHEMA
• ALTER SEQUENCE
• ALTER SERVER
• ALTER SESSION
• ALTER SUBSCRIPTION
• ALTER SYNONYM
• ALTER SYSTEM KILL SESSION
• ALTER SYSTEM SET
• ALTER TABLE
• ALTER TABLE PARTITION
• ALTER TABLE SUBPARTITION
• ALTER TABLESPACE
• ALTER TEXT SEARCH CONFIGURATION
• ALTER TEXT SEARCH DICTIONARY
• ALTER TRIGGER
• ALTER TYPE
• ALTER USER
• ALTER USER MAPPING
• ALTER VIEW
• ANALYZE | ANALYSE
• BEGIN
• CALL
• CHECKPOINT
• CLEAN CONNECTION
• CLOSE
• CLUSTER
• COMMENT
• COMMIT | END
• COMMIT PREPARED
• CONNECT BY
• COPY
• CREATE AGGREGATE
• CREATE AUDIT POLICY
• CREATE CAST
• CREATE CLIENT MASTER KEY
• CREATE COLUMN ENCRYPTION KEY
• CREATE DATABASE
• CREATE DATA SOURCE
• CREATE DIRECTORY
• CREATE EVENT
• CREATE EVENT TRIGGER
• CREATE EXTENSION
• CREATE FOREIGN DATA WRAPPER
• CREATE FOREIGN TABLE
• CREATE FUNCTION
• CREATE GROUP
• CREATE INCREMENTAL MATERIALIZED VIEW
• CREATE INDEX
• CREATE LANGUAGE
• CREATE MASKING POLICY
• CREATE MATERIALIZED VIEW
• CREATE MODEL
• CREATE OPERATOR
• CREATE PACKAGE
• CREATE PROCEDURE
• CREATE PUBLICATION
• CREATE RESOURCE LABEL
• CREATE RESOURCE POOL
• CREATE ROLE
• CREATE ROW LEVEL SECURITY POLICY
• CREATE RULE
• CREATE SCHEMA
• CREATE SEQUENCE
• CREATE SERVER
• CREATE SUBSCRIPTION
• CREATE SYNONYM
• CREATE TABLE
• CREATE TABLE AS
• CREATE TABLE PARTITION
• CREATE TABLESPACE
• CREATE TABLE SUBPARTITION
• CREATE TEXT SEARCH CONFIGURATION
• CREATE TEXT SEARCH DICTIONARY
• CREATE TRIGGER
• CREATE TYPE
• CREATE USER
• CREATE USER MAPPING
• CREATE VIEW
• CREATE WEAK PASSWORD DICTIONARY
• CURSOR
• DEALLOCATE
• DECLARE
• DELETE
• DELIMITER
• DO
• DROP AGGREGATE
• DROP AUDIT POLICY
• DROP CAST
• DROP CLIENT MASTER KEY
• DROP COLUMN ENCRYPTION KEY
• DROP DATABASE
• DROP DATA SOURCE
• DROP DIRECTORY
• DROP EVENT
• DROP EVENT TRIGGER
• DROP EXTENSION
• DROP FOREIGN DATA WRAPPER
• DROP FOREIGN TABLE
• DROP FUNCTION
• DROP GLOBAL CONFIGURATION
• DROP GROUP
• DROP INDEX
• DROP LANGUAGE
• DROP MASKING POLICY
• DROP MATERIALIZED VIEW
• DROP MODEL
• DROP OPERATOR
• DROP OWNED
• DROP PACKAGE
• DROP PROCEDURE
• DROP PUBLICATION
• DROP RESOURCE LABEL
• DROP RESOURCE POOL
• DROP ROLE
• DROP ROW LEVEL SECURITY POLICY
• DROP RULE
• DROP SCHEMA
• DROP SEQUENCE
• DROP SERVER
• DROP SUBSCRIPTION
• DROP SYNONYM
• DROP TABLE
• DROP TABLESPACE
• DROP TEXT SEARCH CONFIGURATION
• DROP TEXT SEARCH DICTIONARY
• DROP TRIGGER
• DROP TYPE
• DROP USER
• DROP USER MAPPING
• DROP VIEW
• DROP WEAK PASSWORD DICTIONARY
• EXECUTE
• EXECUTE DIRECT
• EXPLAIN
• EXPLAIN PLAN
• FETCH
• GRANT
• INSERT
• LOCK
• MERGE INTO
• MOVE
• PREDICT BY
• PREPARE
• PREPARE TRANSACTION
• PURGE
• REASSIGN OWNED
• REFRESH INCREMENTAL MATERIALIZED VIEW
• REFRESH MATERIALIZED VIEW
• REINDEX
• RELEASE SAVEPOINT
• RESET
• REVOKE
• ROLLBACK
• ROLLBACK PREPARED
• ROLLBACK TO SAVEPOINT
• SAVEPOINT
• SELECT
• SELECT INTO
• SET
• SET CONSTRAINTS
• SET ROLE
• SET SESSION AUTHORIZATION
• SET TRANSACTION
• SHOW
• SHOW EVENTS
• SHRINK
• SHUTDOWN
• SNAPSHOT
• START TRANSACTION
• TIMECAPSULE TABLE
• TRUNCATE
• UPDATE
• VACUUM
• VALUES