Amazon Redshift
Database Developer Guide (API Version 2012-12-01)


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

On this page: