DROP FOREIGN TABLE (Delete a foreign table)
Function
Deletes the definition of a foreign table without deleting tables on the foreign server side.
Privileges
Format
DROP FOREIGN TABLE [authorization-identifier.]table-identifier [WITH PROGRAM] |
Operands
When deleting a foreign table, specify this operand to disable functions that use the foreign table in an SQL procedure statement or a valid SQL object in the procedure.
If WITH PROGRAM is omitted, and if there is a function that uses the foreign table or an SQL object with a valid procedure, the foreign table cannot be deleted.
Common rules
Notes