Categories:

DDL Commands

UNDROP <object>

Restores the specified object to the system.

See also:

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

Syntax

UNDROP <object_type> <identifier>

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

Account Objects:

Database Objects:

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;
Back to top