Teradata Drop Database

Teradata Drop Database statement is used to drop an empty database from the Teradata system.

Before dropping a database in Teradata below point should be noted:

1. The user you are using to drop a database should have the appropriate privileges (DROP database) to drop a database.
2. The database you are dropping should be empty before issuing the drop database statement. That means that the database should not contain any objects like tables, views, macros, user defined procedures, etc.
3. In order to drop a database containing other database objects, you must use delete a database statement to make it empty.
4. Once a database is dropped, the PERM and TEMP space of the database to be returned back to the immediate owner database or user.

Teradata Drop Database Syntax

The syntax of the Teradata Drop Database is as follows.

DROP DATABASE database_name;

Teradata Drop Database Example

The following statement drops an empty database named UNIVERSITY.

DROP DATABASE UNIVERSITY;