DROP TABLE/EXTERNAL TABLE/SAMPLE TABLE

DROP TABLE [ IF EXISTS ] [schema-name.]table-name

Description

Removes the specified table. Include the IF EXISTS clause to execute the statement only if the specified table exists in TIBCO ComputeDB. The schema-name. prefix is optional if you are currently using the schema that contains the table.

Example

DROP TABLE IF EXISTS app.customer

Related Topics

• CREATE TABLE

• CREATE EXTERNAL TABLE

• CREATE SAMPLE TABLE

• DELETE TABLE

• SHOW TABLES

• TRUNCATE TABLE