Teradata - Drop Tables

DROP TABLE command is used to drop a table. When the DROP TABLE is issued, data in the table is deleted and the table is dropped.

Syntax

Following is the generic syntax for DROP TABLE.

DROP TABLE <tablename>;

Example

The following example drops the table ‘employee’.

DROP TABLE employee;

If you run the SHOW TABLE command after this, you will get an error message stating that the table doesn’t exist.

SHOW TABLE employee; 
*** Failure 3807 Object 'employee' does not exist. 
   Statement# 1, Info = 0 
*** Total elapsed time was 1 second.