SQL Commands
SQL所有命令
全览图
命令表
| ABORT | COMMENT | DECLARE | EXECUTE |
|---|---|---|---|
| ALTER AGGREGATE | COMMIT | DELETE | EXPLAIN |
| ALTER COLLATION | COMMIT PREPARED | DISCARD | FETCH |
| ALTER CONVERSION | COPY | DO | GRANT |
| ALTER DATABASE | CREATE ACCESS METHOD | DROP ACCESS METHOD | IMPORT FOREIGN SCHEMA |
| ALTER DEFAULT PRIVILEGES | CREATE AGGREGATE | DROP AGGREGATE | INSERT |
| ALTER DOMAIN | CREATE CAST | DROP CAST | LISTEN |
| ALTER EVENT TRIGGER | CREATE COLLATION | DROP COLLATION | LOAD |
| ALTER EXTENSION | CREATE CONVERSION | DROP CONVERSION | LOCK |
| ALTER FOREIGN DATA WRAPPER | CREATE DATABASE | DROP DATABASE | MOVE |
| ALTER FOREIGN TABLE | CREATE DOMAIN | DROP DOMAIN | NOTIFY |
| ALTER FUNCTION | CREATE EVENT TRIGGER | DROP EVENT TRIGGER | PREPARE |
| ALTER GROUP | CREATE EXTENSION | DROP EXTENSION | PREPARE TRANSACTION |
| ALTER INDEX | CREATE FOREIGN DATA WRAPPER | DROP FOREIGN DATA WRAPPER | REASSIGN OWNED |
| ALTER LANGUAGE | CREATE FOREIGN TABLE | DROP FOREIGN TABLE | REFRESH MATERIALIZED VIEW |
| ALTER LARGE OBJECT | CREATE FUNCTION | DROP FUNCTION | REINDEX |
| ALTER MATERIALIZED VIEW | CREATE GROUP | DROP GROUP | RELEASE SAVEPOINT |
| ALTER OPERATOR | CREATE INDEX | DROP INDEX | RESET |
| ALTER OPERATOR CLASS | CREATE LANGUAGE | DROP LANGUAGE | REVOKE |
| ALTER OPERATOR FAMILY | CREATE MATERIALIZED VIEW | DROP MATERIALIZED VIEW | ROLLBACK |
| ALTER POLICY | CREATE OPERATOR | DROP OPERATOR | ROLLBACK PREPARED |
| ALTER ROLE | CREATE OPERATOR CLASS | DROP OPERATOR CLASS | ROLLBACK TO SAVEPOINT |
| ALTER RULE | CREATE OPERATOR FAMILY | DROP OPERATOR FAMILY | SAVEPOINT |
| ALTER SCHEMA | CREATE POLICY | DROP OWNED | SECURITY LABEL |
| ALTER SEQUENCE | CREATE ROLE | DROP POLICY | SELECT |
| ALTER SERVER | CREATE RULE | DROP ROLE | SELECT INTO |
| ALTER SYSTEM | CREATE SCHEMA | DROP RULE | SET |
| ALTER TABLE | CREATE SEQUENCE | DROP SCHEMA | SET CONSTRAINTS |
| ALTER TABLESPACE | CREATE SERVER | DROP SEQUENCE | SET ROLE |
| ALTER TEXT SEARCH CONFIGURATION | CREATE TABLE | DROP SERVER | SET SESSION AUTHORIZATION |
| ALTER TEXT SEARCH DICTIONARY | CREATE TABLE AS | DROP TABLE | SET TRANSACTION |
| ALTER TEXT SEARCH PARSER | CREATE TABLESPACE | DROP TABLESPACE | SHOW |
| ALTER TEXT SEARCH TEMPLATE | CREATE TEXT SEARCH CONFIGURATION | DROP TEXT SEARCH CONFIGURATION | START TRANSACTION |
| ALTER TRIGGER | CREATE TEXT SEARCH DICTIONARY | DROP TEXT SEARCH DICTIONARY | TABLE |
| ALTER TYPE | CREATE TEXT SEARCH PARSER | DROP TEXT SEARCH PARSER | TRUNCATE |
| ALTER USER | CREATE TEXT SEARCH TEMPLATE | DROP TEXT SEARCH TEMPLATE | UNLISTEN |
| ALTER USER MAPPING | CREATE TRANSFORM | DROP TRANSFORM | UPDATE |
| ALTER VIEW | CREATE TRIGGER | DROP TRIGGER | VACUUM |
| ANALYZE | CREATE TYPE | DROP TYPE | VALUES |
| BEGIN | CREATE USER | DROP USER | WITH |
| CHECKPOINT | CREATE USER MAPPING | DROP USER MAPPING | |
| CLOSE | CREATE VIEW | DROP VIEW | |
| CLUSTER | DEALLOCATE | END |