—
NAME
DROP_FOREIGN_TABLE - remove a foreign table
SYNOPSIS
bash
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:
bash
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))