Release History
Requirements

Introduction

Quick onboard

Deployment

Data Modeling

Connection

Write data

Migration

Query

Operations and Maintenance

Performance Tuning

Troubleshooting

Reference 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