The column_options view provides information about all the options defined for foreign table columns in the current database.
| Column name | Data type | Description |
|---|---|---|
table_catalog |
sql_identifier |
The name of the current database containing the foreign table. |
table_schema |
sql_identifier |
The name of the schema containing the foreign table. |
table_name |
sql_identifier |
The name of the foreign table. |
column_name |
sql_identifier |
The name of the column. |
option_name |
sql_identifier |
The name of the option. |
option_value |
character_data |
The value of the option. |