DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
Status
  1. Overview
    • SQL data types reference
    • SQL command reference
        1. Query syntax
        2. Query operators
        3. General DDL
            1. ALTER
              • COMMENT
                • CREATE
                • CREATE OR ALTER
                  • DESCRIBE
                    • DROP
                      • UNDROP
                        • SHOW
                          • USE
                        • General DML
                        • All commands (alphabetical)
                          • Accounts
                          • Users, roles, & privileges
                          • Integrations
                          • Replication & failover
                          • Sessions
                          • Transactions
                          • Virtual warehouses & resource monitors
                          • Databases, schemas, & shares
                          • Tables, views, & sequences
                          • Functions, procedures, & scripting
                          • Streams & tasks
                          • Classes & instances
                          • Machine learning
                          • Cortex Search Service
                          • Listings
                          • Organization profiles
                          • Security
                          • Data Governance
                          • Privacy
                          • Data loading & unloading
                          • File staging
                          • Alerts
                          • Native Apps Framework
                          • Streamlit
                          • Notebook
                          • Snowpark Container Services
                      • Function and stored procedure reference
                      • Class reference
                      • Scripting reference
                      • General reference
                      • API reference
                        ReferenceSQL command referenceGeneral DDLUNDROP

                        UNDROP <object>¶

                        Restores the specified object to the system.

                        See also:

                        CREATE <object> , DROP <object> , SHOW <objects>

                        UNDROP commands¶

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

                        Organization Objects:

                        • UNDROP ACCOUNT

                        Account Objects:

                        • UNDROP DATABASE

                        Database Objects:

                        • UNDROP DYNAMIC TABLE

                        • UNDROP EXTERNAL VOLUME

                        • UNDROP ICEBERG TABLE

                        • UNDROP NOTEBOOK

                        • UNDROP SCHEMA

                        • UNDROP STREAMLIT

                        • UNDROP TABLE

                        • UNDROP TAG

                        Was this page helpful?

                        Visit Snowflake
                        Join the conversation
                        Develop with Snowflake
                        Share your feedback
                        Read the latest on our blog
                        Get your own certification
                        Privacy NoticeSite Terms© 2025 Snowflake, Inc. All Rights Reserved.
                        1. UNDROP commands
                        Language: English
                        • English
                        • Français
                        • Deutsch
                        • 日本語
                        • 한국어
                        • Português