DROP FOREIGN TABLE

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > DROP statements >

DROP FOREIGN TABLE

Previous pageReturn to chapter overviewNext page

DROP FOREIGN TABLE removes the definition of a foreign table that was previously registered by CREATE FOREIGN TABLE or IMPORT FOREIGN SCHEMA.

Syntax

dropforeigntable

Notes

Dropping the foreign table definition within SQLstream does not cause the foreign table at the remote database to be dropped; it merely removes the table's metadata from the SQLstream data dictionary.

If any objects (such as views or pumps) depend on the foreign stream, it cannot be dropped unless the CASCADE option is selected. The default option is RESTRICT.

Examples

SET SCHEMA 'northwind';

DROP FOREIGN TABLE orders;

DROP FOREIGN TABLE southwind.products;

DROP FOREIGN TABLE localdb.sap.expenses;