DROP FOREIGN TABLE

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

Syntax

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;