YMatrix

Quick Start

Cluster Deployment

Data Model

Data Writing

Data Query

SQL Reference

Maintenance and Monitoring

Tool Guide

Troubleshooting

Scenario
Version Release History

DROP FOREIGN TABLE

Delete the appearance.

Summary

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

describe

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