Release History
Help

YMatrix

Quick Start

Deployment

Data Usage

Manage Clusters

Security

Best Practice

Technical Principles

Advanced Features

Guide

SQL Reference

FAQ

DROP FOREIGN TABLE

Delete the appearance.

Synopsis

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

Description

DROP FOREIGN TABLE deletes existing appearance. Only the owner of the appearance can delete it.

Parameters

IF EXISTS

  • If the appearance does not exist, do not report an error. In this case, the YMatrix database will issue a notification.

name

  • The name of the appearance to be deleted (can be specified by the pattern).

CASCADE

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

RESTRICT

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

Example

Delete appearances named films and distributors:

DROP FOREIGN TABLE films, distributors;

Compatibility

DROP FOREIGN TABLE complies with ISO/IEC 9075-9 (SQL/MED), but the standard only allows one appearance per command to be deleted. The IF EXISTS clause is a YMatrix database extension.

See also

ALTER FOREIGN TABLE, DROP FOREIGN TABLE

← Previous
DROP_FOREIGN_DATA_WRAPPER
Next →
DROP_FUNCTION