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 |