SQL Command Reference¶
These topics provide reference information for all the Snowflake SQL commands (DDL, DML, and query syntax).
Query Syntax — structure of SQL queries in Snowflake.
Query Operators — arithmetic, logical, and other types of operators.
DDL (Data Definition Language) Commands — overview of DDL commands.
DML (Data Manipulation Language) Commands — commands for performing DML operations, including:
Inserting, deleting, updating, and merging data in Snowflake tables.
Bulk copying data into and out of Snowflake tables.
Staging files for bulk copying.
All Commands (Alphabetical) — alphabetical list of all the commands.
Commands categorized by the type of objects and operations they control, includng:
General account-level objects (accounts, users, roles, securty policies, integrations, etc.) and operations (failover & recovery, etc.).
Session-based operations (session context, queries, variables, transactions, etc.).
Virtual warehouses (for loading data and performing queries) and resource monitors (for controlling credit usage).
Databases, schemas, tables, and other schema-level objects (views, sequences, etc.).
Snoflake extensions and application development (user-defined functions, stored procedures, scripting, etc.).
Objects for sharing data (shares, listings, etc.).
Objects for classifying, protecting, and governing data (masking polcies, row-access polcies, tags, etc.).