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.
SET SCHEMA 'northwind';
DROP FOREIGN TABLE orders;
DROP FOREIGN TABLE southwind.products;
DROP FOREIGN TABLE localdb.sap.expenses;