ALTER <object>¶

Modifies the metadata of an account-level or database object, or the parameters for a session.

See also:

CREATE <object> , DESCRIBE <object> , SHOW <objects>

ALTER commands¶

For specific syntax, usage notes, and examples, see:

Account and Session Operations:

• ALTER ACCOUNT (account administrators only)
• ALTER SESSION (all users)

Account Objects:

• ALTER APPLICATION
• ALTER APPLICATION PACKAGE
• ALTER APPLICATION PACKAGE … RELEASE DIRECTIVE
• ALTER APPLICATION PACKAGE … VERSION
• ALTER APPLICATION ROLE
• ALTER AUTHENTICATION POLICY
• ALTER CATALOG INTEGRATION
• ALTER COMPUTE POOL
• ALTER CONNECTION
• ALTER DATABASE
• ALTER DATABASE (catalog-linked)
• ALTER DATABASE ROLE
• ALTER DYNAMIC TABLE
• ALTER EXTERNAL ACCESS INTEGRATION
• ALTER EXTERNAL VOLUME
• ALTER FAILOVER GROUP
• ALTER FEATURE POLICY
• ALTER NETWORK POLICY
• ALTER NOTIFICATION INTEGRATION
• ALTER ORGANIZATION PROFILE
• ALTER POSTGRES INSTANCE
• ALTER REPLICATION GROUP
• ALTER RESOURCE MONITOR
• ALTER SECURITY INTEGRATION
• ALTER SHARE
• ALTER STORAGE INTEGRATION
• ALTER ROLE
• ALTER USER
• ALTER WAREHOUSE

Database Objects:

• ALTER AGENT
• ALTER AGGREGATION POLICY
• ALTER ALERT
• ALTER AUTHENTICATION POLICY
• ALTER BACKUP POLICY
• ALTER BACKUP SET
• ALTER CONTACT
• ALTER CORTEX SEARCH SERVICE
• ALTER DATASET
• ALTER DATASET … ADD VERSION
• ALTER DATASET … DROP VERSION
• ALTER DBT PROJECT
• ALTER DCM PROJECT
• ALTER EXPERIMENT
• ALTER EXTERNAL AGENT
• ALTER EXTERNAL TABLE
• ALTER FILE FORMAT
• ALTER FUNCTION
• ALTER FUNCTION (DMF)
• ALTER GIT REPOSITORY
• ALTER ICEBERG TABLE
• ALTER JOIN POLICY
• ALTER LISTING
• ALTER MAINTENANCE POLICY
• ALTER MASKING POLICY
• ALTER MATERIALIZED VIEW
• ALTER MODEL
• ALTER MODEL … ADD VERSION
• ALTER MODEL … DROP VERSION
• ALTER MODEL … MODIFY VERSION
• ALTER MODEL MONITOR
• ALTER NETWORK RULE
• ALTER NOTEBOOK
• ALTER OPENFLOW DATA PLANE
• ALTER ONLINE FEATURE TABLE
• ALTER PACKAGES POLICY
• ALTER PASSWORD POLICY
• ALTER PIPE
• ALTER PRIVACY POLICY
• ALTER PROCEDURE
• ALTER PROJECTION POLICY
• ALTER ROW ACCESS POLICY
• ALTER SCHEMA
• ALTER SECRET
• ALTER SEMANTIC VIEW
• ALTER SEQUENCE
• ALTER SERVICE
• ALTER SESSION POLICY
• ALTER SNAPSHOT
• ALTER SNAPSHOT POLICY — Deprecated (deprecated; prefer ALTER BACKUP POLICY)
• ALTER SNAPSHOT SET — Deprecated (deprecated; prefer ALTER BACKUP SET)
• ALTER STAGE
• ALTER STORAGE LIFECYCLE POLICY
• ALTER STREAM
• ALTER STREAMLIT
• ALTER TABLE
• ALTER TABLE (event tables)
• ALTER TAG
• ALTER TASK
• ALTER TYPE
• ALTER VIEW

Classes:

• ALTER BUDGET
• ALTER SNOWFLAKE.ML.CLASSIFICATION