The DROP FOREIGN TABLE command deletes a foreign table from a foreign
By default, this command will only delete a foreign table if
no views are associated with it; you may explicitly apply this behavior
by specifying the RESTRICT keyword. When the RESTRICT keyword has
been implicitly or explicitly specified, attempting to delete a foreign
table with associated views generates an SQLCODE -321 error.
When the CASCADE keyword is specified, DROP FOREIGN TABLE will
successfully delete the table and any views associated with it.
In order to delete a foreign table, the following conditions
must be met:
The foreign table must exist on a foreign server in
the current namespace. Attempting to delete a non-existent foreign
table generates an SQLCODE -30 error. This error is suppressed by
epcifying the IF EXISTS keywords.
You must have the necessary privileges to delete the
foreign table. Attempting to delete a table without the necessary
privileges generates an SQLCODE -99 error.