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
                          • dbt Projects on Snowflake
                          • 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. This command is part of the Time Travel feature.

                        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 TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.
                        1. UNDROP commands
                        Language: English
                        • English
                        • Français
                        • Deutsch
                        • 日本語
                        • 한국어
                        • Português