SVV_COLUMNS
Use SVV_COLUMNS to view catalog information about the columns of local and external tables and views, including late-binding views.
SVV_COLUMNS is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.
The SVV_COLUMNS view joins table metadata from the System catalog tables (tables with a PG prefix) and the SVV_EXTERNAL_COLUMNS system view. The system catalog tables describe Amazon Redshift database tables. SVV_EXTERNAL_COLUMNS describes external tables that are used with Amazon Redshift Spectrum.
All users can see all rows from the system catalog tables. Regular users can see column definitions from the SVV_EXTERNAL_COLUMNS view only for external tables to which they have been granted access. Although regular users can see table metadata in the system catalog tables, they can only select data from user-defined tables if they own the table or have been granted 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. If the data_type column is numeric, this column returns the number of significant digits in the entire value. |
| numeric_precision_radix | int | The numeric precision radix. If the data_type column is numeric, this column returns the base of the columns numeric_precision and numeric_scale. |
| numeric_scale | int | The numeric scale. If the data_type column is numeric, this column returns the number of significant digits in the decimal value. |
| 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. |