The foreign_table_options view provides information about options defined for foreign tables in the current database.
| Column name | Data type | Description |
|---|---|---|
foreign_table_catalog |
sql_identifier |
The name of the current database containing the foreign table. |
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. |
option_name |
sql_identifier |
The name of the option. |
option_value |
character_data |
The value of the option. |