SQL Command Reference

These topics provide reference information for all the Snowflake SQL commands (DDL, DML, and query syntax).

• Summary of Commands — combined list of all the commands and query syntax and operators. Can be used as a quick-reference.

• All Commands (Alphabetical) — alphabetical list of all the commands.

• DDL Commands — commands categorized by the type of objects they control:

  • Account & Session DDL

  • User & Security DDL

  • Warehouse & Resource Monitor DDL

  • Database, Schema, & Share DDL

  • Data Pipeline DDL

  • Table, View, & Sequence DDL

  • Data Loading / Unloading DDL

  • DDL for User-Defined Functions, External Functions, and Stored Procedures

• DML Commands — commands for performing the following DML operations:

  • Inserting, deleting, updating, and merging data in Snowflake tables.

  • Bulk copying data into and out of Snowflake tables.

  • Staging files for bulk copying.

• Query Syntax — structure of SQL queries in Snowflake.

• Query Operators — arithmetic, logical, and other types of operators.