SVV_EXTERNAL_COLUMNS
Use SVV_EXTERNAL_COLUMNS to view details for columns in external tables.
SVV_EXTERNAL_COLUMNS is visible to all users. Superusers can see all rows; regular users can see only metadata to which they have access. For more information, see CREATE EXTERNAL SCHEMA.
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| schemaname | text | The name of the Amazon Redshift external schema for the external table. |
| tablename | text | The name of the external table. |
| columnname | text | The name of the column. |
| external_type | text | The data type of the column. |
| columnnum | integer | The external column number, starting from 1. |
| part_key | integer | If the column is a partition key, the order of the
key. If the column isn't a partition, the value is
0.
|
