Release History
Help

YMatrix

Quick Start

Deployment

Data Usage

Manage Clusters

Security

Best Practice

Technical Principles

Advanced Features

Guide

SQL Reference

FAQ

DROP TABLE

Delete the table.

Synopsis

DROP TABLE [IF EXISTS] name [, ...] [CASCADE | RESTRICT]

Description

DROP TABLE Deletes tables from the database. Only table owners, schema owners and superusers can delete tables. To clear the row table without deleting the table definition, use DELETE or TRUNCATE.

DROP TABLE always deletes all indexes, rules, triggers, and constraints that exist in the target table. However, to delete a table referenced by a view, CASCADE must be specified. CASCADE will completely remove the dependent view.

Parameters

IF EXISTS

  • If the table does not exist, please do not report an error. In this case, a notification will be issued.

name

  • The name of the table to be deleted (can be specified by the schema).

CASCADE

  • Automatically delete table-dependent objects (such as views).

RESTRICT

  • If there are any object dependencies tables, the table is denied. This is the default value.

Example

Delete table mytable:

DROP TABLE mytable;

Compatibility

DROP TABLE is fully compliant with the SQL standard, but this standard only allows one table to be deleted per command. Additionally, the IF EXISTS option is a YMatrix database extension.

See also

ALTER TABLE, CREATE TABLE

← Previous
DROP_STATISTICS
Next →
DROP_TABLESPACE