UNDROP <object>¶

Syntax¶

UNDROP <object_type> <identifier>

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 SCHEMA

• UNDROP TABLE

• UNDROP TAG

General usage notes¶

• Not all DROP commands have a corresponding UNDROP.

• UNDROP relies on the Snowflake Time Travel feature. An object can be restored only if the object was deleted within the Data retention period. The default value is 24 hours.

Examples¶

UNDROP DATABASE mydb;