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 .
|