DOCUMENTATION
/
Language
English
中文
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
Go to https://china-status.snowflake.com to see details of the 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
                          • Business continuity & disaster recovery
                          • Sessions
                          • Transactions
                          • Virtual warehouses & resource monitors
                          • Databases, schemas, & shares
                          • Tables, views, sequences, and types
                          • Functions, procedures, & scripting
                          • Streams & tasks
                          • DCM Projects
                          • dbt Projects on Snowflake
                          • Classes & instances
                          • Machine learning
                          • Cortex
                          • Listings
                          • Openflow data plane integration
                          • Organization profiles
                          • Security
                          • Data Governance
                          • Privacy
                          • Data loading & unloading
                          • File staging
                          • Storage lifecycle policies
                          • Git
                          • Alerts
                          • Native Apps Framework
                          • Streamlit
                          • Notebook
                          • Snowpark Container Services
                          • Snowflake Postgres
                      • 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 SNAPSHOT

                        • UNDROP STREAMLIT

                        • UNDROP TABLE

                        • UNDROP TAG

                        • UNDROP TYPE

                        Was this page helpful?

                        Visit Snowflake
                        Share your feedback
                        Privacy PolicyTerms of Service
                        © 2026 Snowflake All Rights Reserved.@北京神州数码云计算有限公司版权所有.

                        Alternative interfaces

                        Snowflake Python APIs

                        Snowflake REST APIs

                        Snowflake CLI

                        1. UNDROP commands