• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. DROP TABLE

DROP TABLE

Function

DROP TABLE deletes a specified table.

Precautions

DROP TABLE forcibly deletes a specified table. After a table is deleted, any indexes that exist for the table will be deleted; any functions or stored procedures that use this table cannot be run. Deleting a partitioned table also deletes all partitions in the table.

Syntax

DROP TABLE [ IF EXISTS ] 
    { [schema.]table_name } [, ...] [ CASCADE | RESTRICT ];

Parameter Description

  • IF EXISTS

    Sends a notice instead of an error if the specified table does not exist.

  • schema

    Specifies the schema name.

  • table_name

    Specifies the name of the table.

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes objects (such as views) that depend on the table to be deleted.
    • RESTRICT (default): refuses to delete the table if any objects depend on it. This is the default.

Examples

See Example for CREATE TABLE.

Helpful Links

ALTER TABLE, CREATE TABLE