Teradata - Drop Tables
Advertisements
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.
teradata_tables.htm
Advertisements