Release History
Help

YMatrix

Quick Start

Deployment

Data Usage

Manage Clusters

Security

Best Practice

Technical Principles

Advanced Features

Guide

SQL Reference

FAQ

DROP EXTERNAL TABLE

Delete external table definitions.

Synopsis

DROP EXTERNAL [WEB] TABLE [IF EXISTS] name [CASCADE | RESTRICT]

Description

DROP EXTERNAL TABLE Deletes existing external table definitions from the database system. External data sources or files will not be deleted. To execute this command, you must be the owner of the external table.

Parameters

WEB

  • Optional keywords for deleting external web tables.

IF EXISTS

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

name

  • The name of the existing external table (can be specified by the schema).

CASCADE

  • Automatically delete objects (such as views) that depend on external tables.

RESTRICT

  • If any object depends on an external table, it is rejected. This is the default value.

Example

Delete an external table named staging (if it exists):

DROP EXTERNAL TABLE IF EXISTS staging;

Compatibility

There is no DROP EXTERNAL TABLE statement in the SQL standard.

See also

ALTER EXTERNAL TABLE, CREATE EXTERNAL TABLE

← Previous
DROP_EXTENSION
Next →
DROP_FOREIGN_DATA_WRAPPER