YMatrix

Version Release History
Platform Requirements

YMatrix

Quick Start

Standard Cluster Deployment

Data Modeling

Connecting to The database

Data Writing

Data Migration

Data Query

Maintenance and Monitoring

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

scenario

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