All commands (alphabetical)¶

This topic provides a list of all DDL and DML commands, as well as the SELECT command and other related commands, in alphabetical order.

Command Name	Summary
A
ALTER <object>	Modifies the metadata of an account-level or database object, or the parameters for a session.
ALTER ACCOUNT	Modifies an account.
ALTER AGGREGATION POLICY	Replaces the existing rules or comment of an aggregation policy.
ALTER ALERT	Modifies the properties of an existing alert and suspends or resumes an existing alert.
ALTER API INTEGRATION	Modifies the properties of an existing API integration.
ALTER APPLICATION	Modifies the properties of an installed
ALTER APPLICATION PACKAGE	Modifies the properties of an existing application package in the Native Apps Framework.
ALTER APPLICATION PACKAGE … RELEASE DIRECTIVE	Modifies the properties of an existing application package in the Native Apps Framework.
ALTER APPLICATION PACKAGE … VERSION	Modifies the versioning of an existing application package in the Native Apps Framework.
ALTER APPLICATION ROLE	Modifies the properties for an existing application role.
ALTER AUTHENTICATION POLICY	Modifies the properties of an authentication policy.
ALTER CATALOG INTEGRATION	Modifies the properties of an existing catalog integration.
ALTER COMPUTE POOL	Modifies the properties of an existing compute pool.
ALTER CONNECTION	Modifies the properties for an existing connection.
ALTER CORTEX SEARCH SERVICE	Modifies the properties of an existing Cortex Search service.
ALTER DATABASE	Modifies the properties for an existing database.
ALTER DATABASE ROLE	Modifies the properties for an existing database role.
ALTER DYNAMIC TABLE	Modifies the properties of a dynamic table.
ALTER EXTERNAL ACCESS INTEGRATION	Modifies the properties of an existing external access integration.
ALTER EXTERNAL TABLE	Modifies the properties, columns, or constraints for an existing external table.
ALTER EXTERNAL VOLUME	Modifies the properties for an existing external volume.
ALTER FAILOVER GROUP	Modifies the properties for an existing failover group.
ALTER FILE FORMAT	Modifies the properties for an existing file format object.
ALTER FUNCTION	Modifies the properties of an existing user-defined or external function.
ALTER FUNCTION (DMF)	Modifies the properties of an existing data metric function (DMF).
ALTER FUNCTION (Snowpark Container Services)	Modifies the properties of an existing service function.
ALTER GIT REPOSITORY	Modifies the properties of an existing Git repository stage.
ALTER ICEBERG TABLE	Modifies properties such as clustering options and tags for an existing Apache Iceberg™ table.
ALTER ICEBERG TABLE … ALTER COLUMN … SET DATA TYPE	Modifies (evolves) a structured type column in a Snowflake-managed Apache Iceberg™ table.
ALTER ICEBERG TABLE … CONVERT TO MANAGED	Converts an Apache Iceberg™ table that uses an external Iceberg catalog into a table that uses Snowflake as the catalog (a Snowflake-managed Iceberg table).
ALTER ICEBERG TABLE … REFRESH	Refreshes the metadata for an Apache Iceberg™ table that uses an external Iceberg catalog.
ALTER INTEGRATION	Modifies the properties for an existing integration.
ALTER MASKING POLICY	Replaces the existing masking policy rules with new rules or a new comment and allows the renaming of a masking policy.
ALTER MATERIALIZED VIEW	Alters a materialized view in the current/specified schema.
ALTER MODEL	Modifies the properties for an existing model, including its name, tags, default version, or comment.
ALTER MODEL … ADD VERSION	Adds a new version to an existing model from an existing model version.
ALTER MODEL … DROP VERSION	Removes a version from the specified machine learning model.
ALTER MODEL … MODIFY VERSION	Modifies a version of a model, changing the version’s comment or metadata.
ALTER NETWORK POLICY	Modifies the properties for an existing network policy.
ALTER NETWORK RULE	Modifies an existing network rule.
ALTER NOTEBOOK	Modifies the properties of an existing notebook.
ALTER NOTIFICATION INTEGRATION	Modifies the properties for an existing notification integration.
ALTER NOTIFICATION INTEGRATION (email)	Modifies the properties for an existing notification integration for sending email messages.
ALTER NOTIFICATION INTEGRATION (inbound from an Azure Event Grid topic)	Modifies the properties for an existing notification integration for receiving messages from an Azure Event Grid topic.
ALTER NOTIFICATION INTEGRATION (inbound from a Google Pub/Sub topic)	Modifies the properties for an existing notification integration for receiving messages from a Google Pub/Sub topic.
ALTER NOTIFICATION INTEGRATION (outbound to an Amazon SNS topic)	Modifies the properties for an existing notification integration for sending a message to an Amazon SNS topic.
ALTER NOTIFICATION INTEGRATION (outbound to an Azure Event Grid topic)	Modifies the properties for an existing notification integration for sending a message to an Azure Event Grid topic.
ALTER NOTIFICATION INTEGRATION (outbound to a Google Pub/Sub topic)	Modifies the properties for an existing notification integration for sending a message to a Google Pub/Sub topic.
ALTER NOTIFICATION INTEGRATION (webhooks)	Modifies the properties for an existing notification integration for a webhook.
ALTER ORGANIZATION ACCOUNT	Modifies the properties of an existing organization account.
ALTER PACKAGES POLICY	Modifies the properties for an existing packages policy.
ALTER PASSWORD POLICY	Modifies the properties for an existing password policy.
ALTER PIPE	Modifies a limited set of properties for an existing pipe object.
ALTER PRIVACY POLICY	Modifies the properties of an existing privacy policy.
ALTER PROCEDURE	Modifies the properties for an existing stored procedure.
ALTER PROJECTION POLICY	Replaces the existing projection policy rules with new rules or a new comment and allows the renaming of a projection policy.
ALTER REPLICATION GROUP	Modifies the properties for an existing replication group.
ALTER RESOURCE MONITOR	Modifies the properties and triggers for an existing resource monitor.
ALTER ROLE	Modifies the properties for an existing custom role.
ALTER ROW ACCESS POLICY	Modifies the properties for an existing row access policy, including renaming the policy or replacing the policy rules.
ALTER SCHEMA	Modifies the properties for an existing schema, including renaming the schema or swapping it with another schema, and changing the Time Travel data retention period (if you are using Snowflake Enterprise Edition or higher).
ALTER SECRET	Modifies the properties of an existing secret.
ALTER SECURITY INTEGRATION	Modifies the properties for an existing security integration.
ALTER SECURITY INTEGRATION (External API Authentication)	Modifies the properties of an existing security integration created for External API Authentication.
ALTER SECURITY INTEGRATION (AWS IAM Authentication)	Modifies the properties of an existing security integration created for authenticating with AWS IAM.
ALTER SECURITY INTEGRATION (External OAuth)	Modifies the properties of an existing security integration created for External OAuth.
ALTER SECURITY INTEGRATION (Snowflake OAuth)	Modifies the properties of an existing security integration created for a Snowflake OAuth client.
ALTER SECURITY INTEGRATION (SAML2)	Modifies the properties of an existing SAML2 security integration.
ALTER SECURITY INTEGRATION (SCIM)	Modifies the properties of an existing SCIM security integration.
ALTER SEQUENCE	Modifies the properties for an existing sequence.
ALTER SERVICE	Modifies Snowpark Container Services service configuration, upgrades the code for the service, and allows you to suspend or resume a service.
ALTER SESSION	Sets parameters that change the behavior for the current session.
ALTER SESSION POLICY	Modifies the properties for an existing session policy.
ALTER SHARE	Modifies the properties for an existing share.
ALTER SNAPSHOT	Modifies the properties of an existing snapshot.
ALTER STAGE	Modifies the properties for an existing named internal or external stage.
ALTER STORAGE INTEGRATION	Modifies the properties for an existing storage integration.
ALTER STREAM	Modifies the properties, columns, or constraints for an existing stream.
ALTER STREAMLIT	Modifies the properties of an existing Streamlit object.
ALTER TABLE	Modifies the properties, columns, or constraints for an existing table.
ALTER TABLE … ALTER COLUMN	This topic describes how to modify one or more column properties for a table using an `ALTER COLUMN` clause in a ALTER TABLE statement.
ALTER TABLE (event tables)	Modifies the properties, columns, or constraints for an existing event table.
ALTER TAG	Modifies the properties for an existing tag, including renaming the tag and setting a masking policy on a tag.
ALTER TASK	Modifies the properties for an existing task.
ALTER USER	Modifies the properties and object/session parameters for an existing user in the system.
ALTER VIEW	Modifies the properties for an existing view.
ALTER WAREHOUSE	Suspends or resumes a virtual warehouse, or aborts all queries (and other SQL statements) for a warehouse.
B
BEGIN	Begins a transaction in the current session.
C
CALL	Calls a stored procedure.
CALL (with anonymous procedure)	Creates and calls an anonymous procedure that is like a stored procedure but is not stored for later use.
COMMENT	Adds a comment or overwrites an existing comment for an existing object.
COMMIT	Commits an open transaction in the current session.
COPY FILES	Copies files from one stage to another.
COPY INTO <location>	Unloads data from a table (or query) into one or more files in one of the following locations.
COPY INTO <table>	Loads data from files to an existing table.
CREATE <object>	Creates a new object of the specified type.
CREATE ACCOUNT	Creates a new account in your organization.
CREATE AGGREGATION POLICY	Creates a new aggregation policy in the current/specified schema or replaces an existing aggregation policy.
CREATE ALERT	Creates a new alert in the current schema.
CREATE API INTEGRATION	Creates a new API integration object in the account, or replaces an existing API integration.
CREATE APPLICATION	Creates a new application object using an application package or listing.
CREATE APPLICATION PACKAGE	Creates a new application package that contains the data content and application logic of an application using the Native Apps Framework.
CREATE APPLICATION ROLE	Creates a new application role or replaces an existing application role.
CREATE AUTHENTICATION POLICY	Creates a new authentication policy in the current or specified schema or replaces an existing authentication policy.
CREATE CATALOG INTEGRATION	Creates a new catalog integration for Apache Iceberg™ tables in the account or replaces an existing catalog integration.
CREATE CATALOG INTEGRATION (AWS Glue)	Creates a new catalog integration in the account or replaces an existing catalog integration for Apache Iceberg™ tables that use AWS Glue as the catalog.
CREATE CATALOG INTEGRATION (Object storage)	Creates a new catalog integration in the account or replaces an existing catalog integration for the following sources.
CREATE CATALOG INTEGRATION (Snowflake Open Catalog)	Creates a new catalog integration for Apache Iceberg™ tables that integrate with Snowflake Open Catalog in the account or replaces an existing catalog integration.
CREATE CATALOG INTEGRATION (Apache Iceberg™ REST)	Creates a new catalog integration in the account or replaces an existing catalog integration for Apache Iceberg™ tables managed in a remote catalog that complies with the open source Apache Iceberg™ REST OpenAPI specification.
CREATE <object> … CLONE	Creates a copy of an existing object in the system.
CREATE COMPUTE POOL	Creates a new compute pool in the current account.
CREATE CONNECTION	Creates a new connection in the account.
CREATE CORTEX SEARCH SERVICE	Creates a new Cortex Search service or replaces an existing one.
CREATE DATA METRIC FUNCTION	Creates a new data metric function (DMF) in the current or specified schema, or replaces an existing data metric function.
CREATE DATABASE	Creates a new database in the system.
CREATE DATABASE ROLE	Create a new database role or replace an existing database role in the system.
CREATE DYNAMIC TABLE	Creates a dynamic table, based on a specified query.
CREATE EVENT TABLE	Creates an event table that captures events, including logged messages from functions and procedures.
CREATE EXTERNAL ACCESS INTEGRATION	Creates an external access integration for access to external network locations from a UDF or procedure handler.
CREATE EXTERNAL FUNCTION	Creates a new external function.
CREATE EXTERNAL TABLE	Creates a new external table in the current/specified schema or replaces an existing external table.
CREATE EXTERNAL VOLUME	Creates a new external volume for Apache Iceberg™ tables in the account or replaces an existing external volume.
CREATE FAILOVER GROUP	Creates a new failover group of specified objects in the system.
CREATE FILE FORMAT	Creates a named file format that describes a set of staged data to access or load into Snowflake tables.
CREATE FUNCTION	Creates a new UDF (user-defined function).
CREATE FUNCTION (Snowpark Container Services)	Creates a service function.
CREATE GIT REPOSITORY	Creates a Git repository stage in the schema or replaces an existing Git repository stage.
CREATE HYBRID TABLE	Creates a new hybrid table in the current/specified schema or replaces an existing table.
CREATE ICEBERG TABLE	Creates or replaces an Apache Iceberg™ table in the current/specified schema.
CREATE ICEBERG TABLE (AWS Glue as the Iceberg catalog)	Creates or replaces an Apache Iceberg™ table in the current/specified schema using an Iceberg table that is registered in the AWS Glue Data Catalog.
CREATE ICEBERG TABLE (Delta files in object storage)	Creates or replaces an Apache Iceberg™ table in the current/specified schema using Delta table files in object storage (external cloud storage).
CREATE ICEBERG TABLE (Iceberg files in object storage)	Creates or replaces an Apache Iceberg™ table in the current/specified schema using Iceberg files in object storage (external cloud storage).
CREATE ICEBERG TABLE (Iceberg REST catalog)	Creates or replaces an Apache Iceberg™ table in the current/specified schema for an Iceberg REST catalog.
CREATE ICEBERG TABLE (Snowflake as the Iceberg catalog)	Creates or replaces an Apache Iceberg™ table that uses Snowflake as the Iceberg catalog in the current/specified schema.
CREATE IMAGE REPOSITORY	Creates a new image repository in the current schema.
CREATE INDEX	Creates a new secondary index in an existing hybrid table and populates the index with data.
CREATE INTEGRATION	Creates a new integration in the system or replaces an existing integration.
CREATE MANAGED ACCOUNT	Creates a new managed account.
CREATE MASKING POLICY	Creates a new masking policy in the current/specified schema or replaces an existing masking policy.
CREATE MATERIALIZED VIEW	Creates a new materialized view in the current/specified schema, based on a query of an existing table, and populates the view with data.
CREATE MODEL	Creates a new machine learning model in the current/specified schema or replaces an existing model.
CREATE NETWORK POLICY	Creates a network policy or replaces an existing network policy.
CREATE NETWORK RULE	Creates a network rule or replaces an existing network rule.
CREATE NOTEBOOK	Creates a new Snowflake notebook or replaces an existing notebook.
CREATE NOTIFICATION INTEGRATION	Creates a new notification integration in the account or replaces an existing integration.
CREATE NOTIFICATION INTEGRATION (email)	Creates a new notification integration in the account or replaces an existing integration for sending email messages.
CREATE NOTIFICATION INTEGRATION (inbound from an Azure Event Grid topic)	Creates a new notification integration in the account or replaces an existing integration for receiving messages from an Azure Event Grid topic.
CREATE NOTIFICATION INTEGRATION (inbound from a Google Pub/Sub topic)	Creates a new notification integration in the account or replaces an existing integration for receiving messages from a Google Pub/Sub topic.
CREATE NOTIFICATION INTEGRATION (outbound to an Amazon SNS topic)	Creates a new notification integration in the account or replaces an existing integration for sending a message to an Amazon SNS topic.
CREATE NOTIFICATION INTEGRATION (outbound to an Azure Event Grid topic)	Creates a new notification integration in the account or replaces an existing integration for sending a message to an Azure Event Grid topic.
CREATE NOTIFICATION INTEGRATION (outbound to a Google Pub/Sub topic)	Creates a new notification integration in the account or replaces an existing integration for sending a message to a Google Pub/Sub topic.
CREATE NOTIFICATION INTEGRATION (webhooks)	Creates a new notification integration or replaces an existing integration for a webhook.
CREATE OR ALTER <object>	CREATE OR ALTER commands are DDL commands that combine the functionality of the CREATE command and the ALTER command by enabling you to define an object using the syntax supported by the CREATE <object> command with the limitations of the ALTER <object> command.
CREATE ORGANIZATION ACCOUNT	Creates a new organization account.
CREATE PACKAGES POLICY	Creates a new packages policy or replaces an existing packages policy.
CREATE PASSWORD POLICY	Creates a new password policy or replaces an existing password policy.
CREATE PIPE	Creates a new pipe in the system for defining the COPY INTO <table> statement used by Snowpipe to load data from an ingestion queue into tables.
CREATE PRIVACY POLICY	Creates a new privacy policy or replaces an existing privacy policy.
CREATE PROCEDURE	Creates a new stored procedure.
CREATE PROJECTION POLICY	Creates a new projection policy in the current/specified schema or replaces an existing projection policy.
CREATE REPLICATION GROUP	Creates a new replication group of specified objects in the system.
CREATE RESOURCE MONITOR	Creates a new resource monitor.
CREATE ROLE	Create a new role or replace an existing role in the system.
CREATE ROW ACCESS POLICY	Creates a new row access policy in the current/specified schema or replaces an existing row access policy.
CREATE SCHEMA	Creates a new schema in the current database.
CREATE SECRET	Creates a new secret in the current or specified schema or replaces an existing secret.
CREATE SECURITY INTEGRATION	Creates a new security integration in the account or replaces an existing integration.
CREATE SECURITY INTEGRATION (External API Authentication)	Creates a new security integration for external API Authentication in the account or replaces an existing integration.
CREATE SECURITY INTEGRATION (AWS IAM Authentication)	Creates a new security integration for external authentication using Amazon Web Services (AWS) Identity and Access Management (IAM).
CREATE SECURITY INTEGRATION (External OAuth)	Creates a new External OAuth security integration in the account or replaces an existing integration.
CREATE SECURITY INTEGRATION (Snowflake OAuth)	Creates a new Snowflake OAuth security integration in the account or replaces an existing integration.
CREATE SECURITY INTEGRATION (SAML2)	Creates a new SAML2 security integration in the account or replaces an existing integration.
CREATE SECURITY INTEGRATION (SCIM)	Creates a new SCIM security integration in the account or replaces an existing integration.
CREATE SEQUENCE	Creates a new sequence, which can be used for generating sequential, unique numbers.
CREATE SERVICE	Creates a new Snowpark Container Services service in the current schema.
CREATE SESSION POLICY	Creates a new session policy or replaces an existing session policy.
CREATE SHARE	Creates a new, empty share.
CREATE SNAPSHOT	Creates or replaces a snapshot of a named volume from the specified service instance.
CREATE STAGE	Creates a new named internal or external stage to use for loading data from files into Snowflake tables and unloading data from tables into files.
CREATE STORAGE INTEGRATION	Creates a new storage integration in the account or replaces an existing integration.
CREATE STREAM	Creates a new stream in the current/specified schema or replaces an existing stream.
CREATE STREAMLIT	Creates a new Streamlit application object in Snowflake or replaces an existing Streamlit application object in the same schema.
CREATE TABLE	Creates a new table in the current/specified schema, replaces an existing table, or alters an existing table.
CREATE \| ALTER TABLE … CONSTRAINT	This topic describes how to create constraints by specifying a CONSTRAINT clause in a CREATE TABLE, CREATE HYBRID TABLE, or ALTER TABLE statement.
CREATE TAG	Creates a new tag or replaces an existing tag in the system.
CREATE TASK	Creates a new task in the current/specified schema or replaces an existing task.
CREATE USER	Creates a new user or replaces an existing user in the system.
CREATE OR ALTER VERSIONED SCHEMA	Creates a new versioned schema or modifies an existing versioned schema.
CREATE VIEW	Creates a new view in the current/specified schema, based on a query of one or more existing tables (or any other valid query expression).
CREATE WAREHOUSE	Creates a new virtual warehouse in the system.
D
DELETE	Remove rows from a table.
DESCRIBE <object>	Describes the details for the specified object.
DESCRIBE AGGREGATION POLICY	Describes the details about an aggregation policy, including the creation date, name, and the SQL expression.
DESCRIBE ALERT	Describes the properties of an alert.
DESCRIBE APPLICATION	Displays information about an application object.
DESCRIBE AUTHENTICATION POLICY	Describes the properties of an authentication policy.
DESCRIBE CATALOG INTEGRATION	Describes the properties of a catalog integration.
DESCRIBE COMPUTE POOL	Describes the properties of a compute pool.
DESCRIBE CORTEX SEARCH SERVICE	Describes the properties of a Cortex Search service.
DESCRIBE DATABASE	Describes the database.
DESCRIBE DYNAMIC TABLE	Describes the columns in a dynamic table.
DESCRIBE EVENT TABLE	Describes the columns in an event table.
DESCRIBE EXTERNAL TABLE	Describes the VALUE column and virtual columns in an external table.
DESCRIBE EXTERNAL VOLUME	Describes the properties of an external volume.
DESCRIBE FILE FORMAT	Describes the properties and their current values for a file format, as well as the default values for each property.
DESCRIBE FUNCTION	Describes the specified user-defined function (UDF) or external function, including the signature (i.e. arguments), return value, language, and body (i.e. definition).
DESCRIBE FUNCTION (DMF)	Describes the specified data metric function (DMF), including the signature (arguments), return value, language, and body (definition).
DESCRIBE FUNCTION (Snowpark Container Services)	Describes the specified service function, including the signature (arguments), return value, language, and body (path to the Snowpark Container Services service).
DESCRIBE GIT REPOSITORY	Describes an existing Git repository stage.
DESCRIBE ICEBERG TABLE	Describes either the columns in an Apache Iceberg™ table or the current values, as well as the default values, for the properties of an Iceberg table.
DESCRIBE INTEGRATION	Describes the properties of an integration.
DESCRIBE MASKING POLICY	Describes the details about a masking policy, including the creation date, name, data type, and SQL expression.
DESCRIBE MATERIALIZED VIEW	Describes the columns in a materialized view.
DESCRIBE NETWORK POLICY	Describes the properties specified for a network policy.
DESCRIBE NETWORK RULE	Describes the properties specified for a network rule.
DESCRIBE NOTEBOOK	Describes the properties of a notebook.
DESCRIBE PACKAGES POLICY	Describes the details about a packages policy.
DESCRIBE PASSWORD POLICY	Describes the details about a password policy.
DESCRIBE PIPE	Describes the properties specified for a pipe, as well as the default values of the properties.
DESCRIBE PRIVACY POLICY	Describes the properties of a privacy policy.
DESCRIBE PROCEDURE	Describes the specified stored procedure, including the stored procedure’s signature (i.e. arguments), return value, language, and body (i.e. definition).
DESCRIBE PROJECTION POLICY	Describes the details about a projection policy, including the creation date, name, and the SQL expression.
DESCRIBE RESULT	Describes the columns in the result of a query.
DESCRIBE ROW ACCESS POLICY	Describes a row access policy, including the creation date, name, data type, and SQL expression.
DESCRIBE SCHEMA	Describes the schema.
DESCRIBE SEARCH OPTIMIZATION	Describes the search optimization configuration for a specified table and its columns.
DESCRIBE SECRET	Describes the properties of a secret.
DESCRIBE SEQUENCE	Describes a sequence, including the sequence’s interval.
DESCRIBE SERVICE	Describes the properties of a Snowpark Container Services service (including job services).
DESCRIBE SESSION POLICY	Describes the details about a session policy.
DESCRIBE SHARE	Describes the data objects that are included in a share.
DESCRIBE SNAPSHOT	Describes the properties of a snapshot.
DESCRIBE STAGE	Describes the values specified for the properties in a stage (file format, copy, and location), as well as the default values for each property.
DESCRIBE STREAM	Describes the columns in a stream.
DESCRIBE STREAMLIT	Describes the columns in a Streamlit object.
DESCRIBE TABLE	Describes either the columns in a table or the set of stage properties for the table (current values and default values).
DESCRIBE TASK	Describes the columns in a task.
DESCRIBE TRANSACTION	Describes the transaction, including the start time and the state (running, committed, rolled back).
DESCRIBE USER	Describes a user, including the current values for the user’s properties, as well as the default values.
DESCRIBE VIEW	Describes the columns in a view (or table).
DESCRIBE WAREHOUSE	Describes the warehouse.
DROP <object>	Removes the specified object from the system.
DROP ACCOUNT	Drops an account, which initiates the process of deleting the account.
DROP AGGREGATION POLICY	Removes an aggregation policy from the current/specified schema.
DROP ALERT	Drops an existing alert.
DROP APPLICATION	Removes an application from the system in the Native Apps Framework.
DROP APPLICATION PACKAGE	Removes an application package from the system in the Native Apps Framework.
DROP APPLICATION ROLE	Removes the specified application role from the system.
DROP AUTHENTICATION POLICY	Removes an authentication policy from the system.
DROP CATALOG INTEGRATION	Removes a catalog integration from the account.
DROP COMPUTE POOL	Removes the specified compute pool from the account.
DROP CONNECTION	Removes a connection from the account.
DROP CORTEX SEARCH SERVICE	Removes the specified Cortex Search service from the current schema.
DROP DATABASE	Removes a database from the system.
DROP DATABASE ROLE	Removes the specified database role from the system.
DROP DYNAMIC TABLE	Removes a dynamic table from the current/specified schema.
DROP EXTERNAL TABLE	Removes an external table from the current/specified schema.
DROP EXTERNAL VOLUME	Removes an external volume from the account, but retains a version of the external volume so that it can be recovered using UNDROP EXTERNAL VOLUME.
DROP FAILOVER GROUP	Removes a failover group from the account.
DROP FILE FORMAT	Removes the specified file format from the current/specified schema.
DROP FUNCTION	Removes the specified user-defined function (UDF) or external function from the current/specified schema.
DROP FUNCTION (DMF)	Removes the specified data metric function (DMF) from the current or specified schema.
DROP FUNCTION (Snowpark Container Services)	Removes the specified service function.
DROP GIT REPOSITORY	Removes the specified Git repository stage from the current/specified schema.
DROP ICEBERG TABLE	Removes an Apache Iceberg™ table from the current/specified schema, but retains a version of the Iceberg table so that it can be recovered using UNDROP ICEBERG TABLE.
DROP IMAGE REPOSITORY	Removes the specified image repository from the current or specified schema.
DROP INDEX	Drops a secondary index.
DROP INTEGRATION	Removes an integration from the account.
DROP MANAGED ACCOUNT	Removes a managed account, including all objects created in the account, and immediately restricts access to the account.
DROP MASKING POLICY	Removes a masking policy from the system.
DROP MATERIALIZED VIEW	Removes the specified materialized view from the current/specified schema.
DROP MODEL	Removes a machine learning model from the current/specified schema.
DROP NETWORK POLICY	Removes the specified network policy from the system.
DROP NETWORK RULE	Removes the specified network rule from the system.
DROP NOTEBOOK	Removes the specified notebook from the current/specified schema.
DROP PACKAGES POLICY	Removes a packages policy from the system.
DROP PASSWORD POLICY	Removes a password policy from the system.
DROP PIPE	Removes the specified pipe from the current/specified schema.
DROP PRIVACY POLICY	Removes the specified privacy policy from the current/specified schema.
DROP PROCEDURE	Removes the specified stored procedure from the current/specified schema.
DROP PROJECTION POLICY	Removes a projection policy from the current/specified schema.
DROP REPLICATION GROUP	Removes a replication group from the account.
DROP RESOURCE MONITOR	Removes the specified resource monitor from the system.
DROP ROLE	Removes the specified role from the system.
DROP ROW ACCESS POLICY	Removes a row access policy from the system.
DROP SCHEMA	Removes a schema from the current/specified database.
DROP SECRET	Removes a secret from the system.
DROP SEQUENCE	Removes a sequence from the current/specified schema.
DROP SERVICE	Removes the specified Snowpark Container Services service from the current or specified schema.
DROP SESSION POLICY	Removes a session policy from the system.
DROP SHARE	Removes the specified share from the system and immediately revokes access for all consumers (i.e. accounts who have created a database from the share).
DROP SNAPSHOT	Removes a snapshot.
DROP STAGE	Removes the specified named internal or external stage from the current/specified schema.
DROP STREAM	Removes a stream from the current/specified schema.
DROP STREAMLIT	Removes the specified Streamlit object from the current/specified schema.
DROP TABLE	Removes a table from the current/specified schema, but retains a version of the table so that it can be recovered using UNDROP TABLE.
DROP TAG	Removes a tag from the system.
DROP TASK	Removes a task from the current/specified schema.
DROP USER	Removes the specified user from the system.
DROP VIEW	Removes the specified view from the current/specified schema.
DROP WAREHOUSE	Removes the specified virtual warehouse from the system.
E
EXECUTE ALERT	Manually executes an alert independent of the schedule for the alert.
EXECUTE IMMEDIATE	Executes a string that contains a SQL statement or a Snowflake Scripting statement.
EXECUTE IMMEDIATE FROM	EXECUTE IMMEDIATE FROM executes the SQL statements specified in a file in a stage.
EXECUTE JOB SERVICE	Executes a Snowpark Container Services service as a job.
EXECUTE NOTEBOOK	Executes all the cells in the live version of a notebook.
EXECUTE TASK	Manually triggers an asynchronous single run of a task (either a standalone task or the root task in a task graph) independent of the schedule defined for the task.
EXPLAIN	Returns the logical execution plan for the specified SQL statement.
G
GET	Downloads data files from one of the following internal stage types to a local directory or folder on a client machine.
GRANT APPLICATION ROLE	Assigns an application role to an account role or another application role.
GRANT DATABASE ROLE	Assigns a database role to an account role or another database role.
GRANT DATABASE ROLE … TO SHARE	Grants a database role to a share.
GRANT OWNERSHIP	Transfers ownership of an object or all objects of a specified type in a schema from one role to another role.
GRANT <privileges>	Grants one or more access privileges on a securable object to a role or database role.
GRANT <privileges> … TO APPLICATION	Grants one or more access privileges on a securable object to an application.
GRANT <privileges> … TO APPLICATION ROLE	Grants one or more access privileges on a securable schema-level object to an application role.
GRANT <privilege> … TO SHARE	Grants access privileges for databases and other supported database objects (schemas, UDFs, tables, and views) to a share.
GRANT ROLE	Assigns a role to a user or another role.
GRANT SERVICE ROLE	Assigns a service role to an account role, application role, or database role.
I
INSERT	Updates a table by inserting one or more rows into the table.
INSERT (multi-table)	Updates multiple tables by inserting one or more rows with column values (from a query) into the tables.
L
LIST	Returns a list of files that have been staged (i.e. uploaded from a local file system or unloaded from a table) in one of the following Snowflake stages.
M
MERGE	Inserts, updates, and deletes values in a table based on values in a second table or a subquery.
P
PUT	Uploads data files from a local file system to one of the following Snowflake stages.
R
REMOVE	Removes files from either an external (external cloud storage) or internal (i.e. Snowflake) stage.
REVOKE APPLICATION ROLE	Revokes an application role from an account role or another application role.
REVOKE DATABASE ROLE	Revokes a database role from an account role or another database role.
REVOKE DATABASE ROLE … FROM SHARE	Revokes a database role from a share.
REVOKE <privileges>	Removes one or more privileges on a securable object from a role or database role.
REVOKE <privileges> FROM APPLICATION	Revokes one or more access privileges on a securable object from an application.
REVOKE <privileges> FROM APPLICATION ROLE	Revokes one or more access privileges on a securable schema-level object from an application role.
REVOKE <privilege> … FROM SHARE	Revokes access privileges for databases and other supported database objects (schemas, tables, and views) from a share.
REVOKE ROLE	Removes a role from another role or a user.
REVOKE SERVICE ROLE	Revokes a service role from an account role, application role, or database role.
ROLLBACK	Rolls back an open transaction in the current session.
S
SELECT	SELECT can be used as either a statement or as a clause within other statements.
SET	Initializes the value of a session variable to the result of a SQL expression.
SHOW <objects>	Lists the existing objects for the specified object type.
SHOW ACCOUNTS	Lists all the accounts in your organization, excluding managed accounts.
SHOW AGGREGATION POLICIES	Lists information about existing aggregation policies, including the creation date, database and schema names, owner, and any available comments.
SHOW ALERTS	Lists the alerts for which you have access privileges.
SHOW APPLICATION PACKAGES	Lists the application packages for which you have access privileges across your entire account in the Native Apps Framework.
SHOW APPLICATION ROLES	Lists the application roles in the specified app for which for which you have access privileges.
SHOW APPLICATIONS	Lists the application objects for which you have access privileges across your entire account in the
SHOW AUTHENTICATION POLICIES	Lists all authentication policies defined in the system.
SHOW CATALOG INTEGRATIONS	Lists the catalog integrations in your account.
SHOW CHANNELS	Lists the Snowpipe Streaming channels for which you have access privileges.
SHOW CLASSES	Lists all available classes.
SHOW COLUMNS	Lists the columns in the tables or views for which you have access privileges.
SHOW COMPUTE POOLS	Lists the compute pools in your account for which you have access privileges.
SHOW CONNECTIONS	Lists the connections for which you have access privileges.
SHOW CORTEX SEARCH SERVICES	Lists the Cortex Search services for which you have access privileges.
SHOW DATA METRIC FUNCTIONS	Lists the data metric functions (DMFs) for which you have access privileges.
SHOW DATABASE ROLES	Lists all the database roles in the specified database.
SHOW DATABASES	Lists the databases for which you have access privileges across your entire account, including dropped databases that are still within the Time Travel retention period and, therefore, can be undropped.
SHOW DATABASES IN FAILOVER GROUP	Lists databases in a failover group.
SHOW DATABASES IN REPLICATION GROUP	Lists databases in a replication group.
SHOW DELEGATED AUTHORIZATIONS	Lists the active delegated authorizations for which you have access privileges.
SHOW DYNAMIC TABLES	Lists the dynamic tables for which you have access privileges.
SHOW ENDPOINTS	Lists the endpoints in a Snowpark Container Services service (or a job service).
SHOW EVENT TABLES	Lists the event tables for which you have access privileges, including dropped tables that are still within the Time Travel retention period and, therefore, can be undropped.
SHOW EXTERNAL FUNCTIONS	Lists all the external functions created for your account.
SHOW EXTERNAL TABLES	Lists the external tables for which you have access privileges.
SHOW EXTERNAL VOLUMES	Lists the external volumes in your account for which you have access privileges.
SHOW FAILOVER GROUPS	Lists the primary and secondary failover groups in your account, as well as the failover groups in other accounts that are associated with your account.
SHOW FILE FORMATS	Lists the file formats for which you have access privileges.
SHOW FUNCTIONS	Lists native, user-defined, and external functions.
SHOW FUNCTIONS IN MODEL	Lists functions defined in machine learning models.
SHOW GIT BRANCHES	Lists the Git repository branches in the specified repository.
SHOW GIT REPOSITORIES	Lists the Git repository stages that you have privileges to access.
SHOW GIT TAGS	Lists the Git repository tags in the specified Git repository.
SHOW GLOBAL ACCOUNTS	Lists all the accounts in your organization that are enabled for replication and indicates the Snowflake Region in which each account is located.
SHOW GRANTS	Lists all access control privileges that have been explicitly granted to roles, users, and shares.
SHOW HYBRID TABLES	Lists the hybrid tables for which you have access privileges.
SHOW ICEBERG TABLES	Lists the Apache Iceberg™ tables for which you have access privileges.
SHOW IMAGE REPOSITORIES	Lists the image repositories for which you have access privileges.
SHOW IMAGES IN IMAGE REPOSITORY	Lists the images in an image repository.
SHOW INDEXES	Lists all the indexes in your account for which you have access privileges.
SHOW INTEGRATIONS	Lists the integrations in your account.
SHOW LOCKS	Lists all running transactions that have locks on resources.
SHOW MANAGED ACCOUNTS	Lists the managed accounts created for your account.
SHOW MASKING POLICIES	Lists masking policy information, including the creation date, database and schema names, owner, and any available comments.
SHOW MATERIALIZED VIEWS	Lists the materialized views that you have privileges to access.
SHOW MODELS	Lists the machine learning models that you have privileges to access.
SHOW NETWORK POLICIES	Lists all network policies defined in the system.
SHOW NETWORK RULES	Lists all network rules defined in the system.
SHOW NOTEBOOKS	Lists the notebooks for which you have access privileges.
SHOW OBJECTS	Lists the tables and views for which you have access privileges.
SHOW ORGANIZATION ACCOUNTS	Lists the organization account of the organization.
SHOW PACKAGES POLICIES	Lists packages policy information.
SHOW PARAMETERS	Lists all the account, session, and object parameters that can be set, as well as the current and default values for each parameter.
SHOW PASSWORD POLICIES	Lists password policy information, including the creation date, database and schema names, owner, and any available comments.
SHOW PIPES	Lists the pipes for which you have access privileges.
SHOW PRIMARY KEYS	Lists primary keys for one or more tables.
SHOW PRIVACY POLICIES	Lists the privacy policies for which you have access privileges.
SHOW PRIVILEGES	Lists the privileges granted to an application.
SHOW PROCEDURES	Lists the stored procedures that you have privileges to access.
SHOW PROJECTION POLICIES	Lists projection policy information, including the creation date, database and schema names, owner, and any available comments.
SHOW REFERENCES	Lists the references defined for an application in the manifest file and the references the consumer has associated to the application.
SHOW REGIONS	Lists all the regions in which accounts can be created.
SHOW RELEASE DIRECTIVES	Lists the release directives defined for an application package in the Native Apps Framework.
SHOW REPLICATION ACCOUNTS	Lists all the accounts in your organization that are enabled for replication and indicates the region in which each account is located.
SHOW REPLICATION DATABASES	Lists all the primary and secondary databases (that is to say, all the databases for which replication has been enabled) in your account and indicates the region in which each account is located.
SHOW REPLICATION GROUPS	Lists each primary or secondary replication or failover group in this account.
SHOW RESOURCE MONITORS	Lists all the resource monitors in your account for which you have access privileges.
SHOW ROLES	Lists all the roles which you can view across your entire account, including the system-defined roles and any custom roles that exist.
SHOW ROLES IN SERVICE	Lists all the service roles associated with a service.
SHOW ROW ACCESS POLICIES	Lists the row access policies for which you have access privileges.
SHOW SCHEMAS	Lists the schemas for which you have access privileges, including dropped schemas that are still within the Time Travel retention period and, therefore, can be undropped.
SHOW SECRETS	Lists the secrets for which you have rights to see.
SHOW SEQUENCES	Lists all the sequences for which you have access privileges.
SHOW SERVICE CONTAINERS IN SERVICE	Lists the containers in all instances of a service.
SHOW SERVICE INSTANCES IN SERVICE	Lists instances of a service.
SHOW SERVICES	Lists the Snowpark Container Services services (including job services) for which you have access privileges.
SHOW SESSION POLICIES	Lists session policy information, including the creation date, database and schema names, owner, and any available comments.
SHOW SHARES	Lists all shares available in the system.
SHOW SHARES IN FAILOVER GROUP	Lists shares in a failover group.
SHOW SHARES IN REPLICATION GROUP	Lists shares in a replication group.
SHOW SNAPSHOTS	Lists the snapshots for which you have access privileges.
SHOW STAGES	Lists all the stages for which you have access privileges.
SHOW STREAMLITS	Lists the Streamlit objects for which you have access privileges.
SHOW STREAMS	Lists the streams for which you have access privileges.
SHOW TABLES	Lists the tables for which you have access privileges, including dropped tables that are still within the Time Travel retention period and, therefore, can be undropped.
SHOW TAGS	Lists the tag information.
SHOW TASKS	Lists the tasks for which you have access privileges.
SHOW TELEMETRY EVENT DEFINITIONS	Lists the event definitions for the specified app.
SHOW TRANSACTIONS	List all running transactions.
SHOW USER FUNCTIONS	Lists all user-defined functions (UDFs) for which you have access privileges.
SHOW USERS	Lists all users in the system.
SHOW VARIABLES	Lists all variables defined in the current session.
SHOW VERSIONS	Lists the versions defined in the specified application package.
SHOW VERSIONS IN MODEL	Lists the versions in a machine learning model.
SHOW VIEWS	Lists the views, including secure views, for which you have access privileges.
SHOW WAREHOUSES	Lists all the warehouses in your account for which you have access privileges.
T
TRUNCATE MATERIALIZED VIEW	Removes all rows from a materialized view, but leaves the view intact (including all privileges and constraints on the materialized view).
TRUNCATE TABLE	Removes all rows from a table but leaves the table intact (including all privileges and constraints on the table).
U
UNDROP <object>	Restores the specified object to the system.
UNDROP ACCOUNT	Restores a dropped account that has not yet been permanently deleted (a dropped account that is within its grace period).
UNDROP DATABASE	Restores the most recent version of a dropped database.
UNDROP DYNAMIC TABLE	Restores the most recent version of a dropped dynamic table.
UNDROP EXTERNAL VOLUME	Restores the most recent version of a dropped external volume.
UNDROP ICEBERG TABLE	Restores the most recent version of a dropped Apache Iceberg™ table.
UNDROP SCHEMA	Restore the most recent version of a dropped schema.
UNDROP TABLE	Restores the most recent version of a dropped table.
UNDROP TAG	Restores the most recent version of a tag to the system.
UNSET	Drops a session variable.
UPDATE	Updates specified rows in the target table with new values.
USE <object>	Specifies the role, warehouse, database, or schema to use for the current session.
USE DATABASE	Specifies the active/current database for the session.
USE ROLE	Specifies the active/current primary role for the session.
USE SCHEMA	Specifies the active/current schema for the session.
USE SECONDARY ROLES	Specifies the active/current secondary roles for the session.
USE WAREHOUSE	Specifies the active/current warehouse for the session.