15.00 - DROP Processes - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

DROP Processes

The drop operation performs the following processes:

1 Sets an exclusive lock on the database.

2 Verifies that the database is empty.

If the database is not empty, then the DROP DATABASE action aborts.

3 Verifies that the database does not own any other databases or users.

If the database owns any databases or users, then the DROP DATABASE action aborts.

4 Drops the database.

5 Adds the PERM and TEMP space that the drop makes available to that of the immediate owner database or user.

After a database is dropped, you cannot recover it by using the Dump and Restore utility unless it is restored.