15.00 - DROP Processes - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.