SQL Commands (Individual Pages)

This directory contains per-command pages with syntax, operational behavior, and examples.

How to use this section

• Start with SQL Command Catalog for grouped coverage.
• Use per-command pages for detailed execution behavior.
• For expression semantics, use SQL Constraints and SQL Value Expressions.

Command page conventions

• Common template sections:
• Command Snapshot
• Purpose
• Syntax
• Operational Notes
• When to Use
• When Not to Use
• Common Errors and Troubleshooting
• Cross-References
• Detailed Reference

Command index

• 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 TABLE
• REFRESH TABLE
• RESTORE SNAPSHOT
• REVOKE
• SELECT
• SET and RESET
• SET/RESET SESSION AUTHORIZATION
• SET TRANSACTION
• SHOW (Session Settings)
• SHOW COLUMNS
• SHOW CREATE TABLE
• SHOW SCHEMAS
• SHOW TABLES
• START TRANSACTION
• UPDATE
• VALUES
• WITH (CTE)
• CREATE GRAPH
• ALTER GRAPH
• DROP GRAPH
• CREATE VERTEX TABLE
• ALTER VERTEX TABLE
• DROP VERTEX TABLE
• CREATE EDGE TABLE
• ALTER EDGE TABLE
• DROP EDGE TABLE
• CREATE MEMORY
• ALTER MEMORY
• DROP MEMORY
• CREATE CONTRACT
• ALTER CONTRACT
• DROP CONTRACT
• CREATE POLICY
• ALTER POLICY
• DROP POLICY
• VALIDATE TABLE
• SET LICENSE KEY