drop_foreign_table(7)

NAME#

DROP_FOREIGN_TABLE - remove a foreign table

SYNOPSIS#

DROP FOREIGN TABLE [ IF EXISTS ] \nname\n [, ...] [ CASCADE | RESTRICT ]

DESCRIPTION#

DROP FOREIGN TABLE removes a foreign table. Only the owner of a foreign table can remove it.

PARAMETERS#

IF EXISTS

name

CASCADE

RESTRICT

EXAMPLES#

To destroy two foreign tables, films and distributors:

DROP FOREIGN TABLE films, distributors;

COMPATIBILITY#

This command conforms to ISO/IEC 9075-9 (SQL/MED), except that the standard only allows one foreign table to be dropped per command, and apart from the IF EXISTS option, which is a PostgreSQL extension.

SEE ALSO#

ALTER FOREIGN TABLE (ALTER_FOREIGN_TABLE(7)), CREATE FOREIGN TABLE (CREATE_FOREIGN_TABLE(7))