Skip to main content

DROP FOREIGN TABLE (SQL)

Drops a foreign table.

Synopsis

DROP FOREIGN TABLE [ IF EXISTS ] table-name [ RESTRICT | CASCADE ]

Arguments

Arguments Description
IF EXISTS Optional — Suppresses the error that arises if a foreign table with table-name does not exist.
table-name The name of the foreign table to be dropped. This name must be a valid identifier. A foreign table by this name must exist for the command to execute successfully.
RESTRICT Optional — Specifies that the foreign table should not be dropped if any SQL objects, such as views, are defined on the foreign table. This option supplies the default behavior.
CASCADE Optional — Specifies that all objects defined on the foreign table, such as views, are dropped with the 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.

Examples

The following example deletes a foreign table that does not have any objects defined on it.

DROP FOREIGN TABLE Example.MyTable RESTRICT

The following example deletes a foreign table and any views associated with it.

DROP FOREIGN TABLE Example.MyTable CASCADE

See Also

FeedbackOpens in a new tab