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


Use SVV_COLUMNS to view catalog information about the columns of local and external tables and views.

SVV_COLUMNS is visible to all users. Superusers can see all rows; regular users can see only metadata to which they have access.

Table Columns

Column Name Data Type Description
table_catalog text The name of the catalog where the table is.
table_schema text The schema name for the table.
table_name text The name of the table.
column_name text The name of the column.
ordinal_position int The position of the column in the table.
column_default text The default value of the column.
is_nullable text A value that indicates whether the column is nullable.
data_type text The data type of the column.
character_maximum_length int The maximum number of characters in the column.
numeric_precision int The numeric precision.
numeric_precision_radix int The numeric precision radix.
numeric_scale int The numeric scale.
datetime_precision int The datetime precision.
interval_type text The interval type.
interval_precision text The interval precision.
character_set_catalog text The character set catalog.
character_set_schema text The character set schema.
character_set_name text The character set name.
collation_catalog text The collation catalog.
collation_schema text The collation schema.
collation_name text The collation name.
domain_name text The domain name.
remarks text Remarks

On this page: