Snowflake logo
Getting Started
Guides
Developer
Reference
Releases
Status
Ctrl+K

Reference

  1. Overview
    • SQL Command Reference
      • Query Syntax
        • Query Operators
          • General DDL
            • ALTER
              • COMMENT
                • CREATE
                  • DESCRIBE
                    • DROP
                      • UNDROP
                        • SHOW
                          • USE
                          • General DML
                            • All Commands (Alphabetical)
                              • Accounts
                                • Users, Roles, & Privileges
                                  • Integrations
                                    • Security Policies
                                      • Replication & Failover
                                        • Sessions
                                          • Transactions
                                            • Virtual Warehouses & Resource Monitors
                                              • Databases, Schemas, & Shares
                                                • Tables, Views, & Sequences
                                                  • Functions, Procedures, & Scripting
                                                    • Streams & Tasks
                                                      • Data Governance
                                                        • Secret
                                                          • Data Loading & Unloading
                                                            • File Staging
                                                              • Alerts
                                                              • Function Reference
                                                                • Scripting Reference
                                                                  • General Reference
                                                                    • API Reference
                                                                      ReferenceSQL Command ReferenceGeneral DDLALTER

                                                                      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>

                                                                      Syntax¶

                                                                      ALTER ACCOUNT SET <params>
                                                                      
                                                                      ALTER SESSION SET <params>
                                                                      
                                                                      ALTER <object_type> <object_name> <actions>
                                                                      
                                                                      Copy

                                                                      Where actions are specific to the object type.

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

                                                                      Account and Session Operations:

                                                                      • ALTER ACCOUNT (account administrators only)

                                                                      • ALTER SESSION (all users)

                                                                      Account Objects:

                                                                      • ALTER CONNECTION

                                                                      • ALTER DATABASE

                                                                      • ALTER DATABASE ROLE

                                                                      • ALTER NETWORK POLICY

                                                                      • ALTER NOTIFICATION INTEGRATION

                                                                      • ALTER RESOURCE MONITOR

                                                                      • ALTER SECURITY INTEGRATION

                                                                      • ALTER SHARE

                                                                      • ALTER STORAGE INTEGRATION

                                                                      • ALTER ROLE

                                                                      • ALTER USER

                                                                      • ALTER WAREHOUSE

                                                                      Database Objects:

                                                                      • ALTER ALERT

                                                                      • ALTER EXTERNAL TABLE

                                                                      • ALTER FILE FORMAT

                                                                      • ALTER FUNCTION

                                                                      • ALTER MASKING POLICY

                                                                      • ALTER MATERIALIZED VIEW

                                                                      • ALTER PASSWORD POLICY

                                                                      • ALTER PIPE

                                                                      • ALTER PROCEDURE

                                                                      • ALTER ROW ACCESS POLICY

                                                                      • ALTER SCHEMA

                                                                      • ALTER SECRET

                                                                      • ALTER SEQUENCE

                                                                      • ALTER SESSION POLICY

                                                                      • ALTER STAGE

                                                                      • ALTER STREAM

                                                                      • ALTER TABLE

                                                                      • ALTER TABLE (Event Tables)

                                                                      • ALTER TAG

                                                                      • ALTER TASK

                                                                      • ALTER VIEW

                                                                      Was this page helpful?

                                                                      Snowflake logo
                                                                      Visit Snowflake
                                                                      Have feedback? Let us know
                                                                      Join the conversation in our community
                                                                      Read the latest on our blog
                                                                      Develop with Snowflake
                                                                      Get your Snowflake certification
                                                                      Privacy NoticeSite Terms© 2023 Snowflake, Inc. All Rights Reserved.
                                                                      1. Syntax
                                                                      Language: English
                                                                      English
                                                                      Français
                                                                      Deutsch
                                                                      日本語
                                                                      한국어
                                                                      Português