SQL Statements

Table of contents

• ALTER CLUSTER
• ALTER PUBLICATION
• ALTER ROLE
• ALTER SERVER
• ALTER TABLE
• ALTER USER
• ANALYZE
• BEGIN
• CLOSE
• COMMIT
• COPY FROM
• COPY TO
• CREATE ANALYZER
• CREATE BLOB TABLE
• CREATE FOREIGN TABLE
• CREATE FUNCTION
• CREATE PUBLICATION
• CREATE REPOSITORY
• CREATE ROLE
• CREATE SERVER
• CREATE SNAPSHOT
• CREATE SUBSCRIPTION
• CREATE TABLE
• CREATE TABLE AS
• CREATE USER
• CREATE USER MAPPING
• CREATE VIEW
• DEALLOCATE
• DECLARE
• DELETE
• DENY
• DISCARD
• DROP ANALYZER
• DROP FOREIGN TABLE
• DROP FUNCTION
• DROP PUBLICATION
• DROP REPOSITORY
• DROP ROLE
• DROP SERVER
• DROP SNAPSHOT
• DROP SUBSCRIPTION
• DROP TABLE
• DROP USER
• DROP USER MAPPING
• DROP VIEW
• END
• EXPLAIN
• FETCH
• GRANT
• INSERT
• KILL
• OPTIMIZE
• REFRESH
• RESTORE SNAPSHOT
• REVOKE
• SELECT
• SET and RESET
• SET LICENSE
• SET AND RESET SESSION AUTHORIZATION
• SET TRANSACTION
• SHOW (session settings)
• SHOW COLUMNS
• SHOW CREATE TABLE
• SHOW SCHEMAS
• SHOW TABLES
• START TRANSACTION
• UPDATE
• VALUES
• WITH