skip to main content
Supported SQL and Extensions : Salesforce, Marketing Cloud, Service Cloud, Dynamics, and Rollbase : Drop Table
 

Try DataDirect Cloud Now

Drop Table

Purpose

Supported only for Salesforce-based data stores. The Drop Table statement drops (removes) a table, its data, and its indexes.

Syntax

DROP TABLE table_name [IF EXISTS] [RESTRICT | CASCADE]
where:
table_name
Specifies the name of an existing table to drop.
IF EXISTS
Specifies that an error is not to be returned if the table does not exist.
RESTRICT
Is in effect by default, meaning that the drop fails if any tables or views reference this table.
CASCADE
Specifies that the drop extends to linked objects and any tables that reference the specified table are dropped also.