The foreign_tables view provides information about all foreign tables defined in the current database.
| Column name | Data type | Description |
|---|---|---|
foreign_table_catalog |
sql_identifier |
The name of the current database in which the foreign table is defined. |
foreign_table_schema |
sql_identifier |
The name of the schema containing the foreign table. |
foreign_table_name |
sql_identifier |
The name of the foreign table. |
foreign_server_catalog |
sql_identifier |
The name of the current database in which the foreign server is defined. |
foreign_server_name |
sql_identifier |
The name of the foreign server. |