NAME

DROP_FOREIGN_TABLE - remove a foreign table

SYNOPSIS

DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ 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))