DROP TABLE

Remove the specified table.

Syntax

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 GemFire XD. The schema-name. prefix is optional if you are currently using the schema that contains the table.

Note: Triggers, constraints (primary, unique, check and references from the table being dropped) and indexes on the table are silently dropped. Dropping a table invalidates statements that depend on the table.