Drops a foreign table.
Description
The DROP FOREIGN TABLE command deletes a foreign table from a foreign server.
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.