COLUMNS View

This Information Schema view displays a row for each column in the tables defined in the specified (or current) database.

See also:

DATABASES View

Columns

Column Name

Data Type

Description

TABLE_CATALOG

TEXT

Database that the table belongs to

TABLE_SCHEMA

TEXT

Schema that the table belongs to

TABLE_NAME

TEXT

Table or View that the column belongs to

COLUMN_NAME

TEXT

Name of the column

ORDINAL_POSITION

NUMBER

Ordinal position of the column in the table

COLUMN_DEFAULT

TEXT

Default value of the column

IS_NULLABLE

TEXT

‘YES’ if the column may contain NULL, ‘NO’ otherwise

DATA_TYPE

TEXT

Data type of the column

CHARACTER_MAXIMUM_LENGTH

NUMBER

Maximum length in characters of string columns

CHARACTER_OCTET_LENGTH

NUMBER

Maximum length in bytes of string columns

NUMERIC_PRECISION

NUMBER

Numeric precision of numeric columns

NUMERIC_PRECISION_RADIX

NUMBER

Radix of precision of numeric columns

NUMERIC_SCALE

NUMBER

Scale of numeric columns

DATETIME_PRECISION

NUMBER

Not applicable for Snowflake.

INTERVAL_TYPE

TEXT

Not applicable for Snowflake.

INTERVAL_PRECISION

NUMBER

Not applicable for Snowflake.

CHARACTER_SET_CATALOG

TEXT

Not applicable for Snowflake.

CHARACTER_SET_SCHEMA

TEXT

Not applicable for Snowflake.

CHARACTER_SET_NAME

TEXT

Not applicable for Snowflake.

COLLATION_CATALOG

TEXT

Not applicable for Snowflake.

COLLATION_SCHEMA

TEXT

Not applicable for Snowflake.

COLLATION_NAME

TEXT

The collation specification for this column

DOMAIN_CATALOG

TEXT

Not applicable for Snowflake.

DOMAIN_SCHEMA

TEXT

Not applicable for Snowflake.

DOMAIN_NAME

TEXT

Not applicable for Snowflake.

UDT_CATALOG

TEXT

Not applicable for Snowflake.

UDT_SCHEMA

TEXT

Not applicable for Snowflake.

UDT_NAME

TEXT

Not applicable for Snowflake.

SCOPE_CATALOG

TEXT

Not applicable for Snowflake.

SCOPE_SCHEMA

TEXT

Not applicable for Snowflake.

SCOPE_NAME

TEXT

Not applicable for Snowflake.

MAXIMUM_CARDINALITY

NUMBER

Not applicable for Snowflake.

DTD_IDENTIFIER

TEXT

Not applicable for Snowflake.

IS_SELF_REFERENCING

TEXT

Not applicable for Snowflake.

IS_IDENTITY

TEXT

Whether this column is an identity column

IDENTITY_GENERATION

TEXT

Whether an identity column’s value is always generated or only generated by default. Snowflake only supports BY DEFAULT

IDENTITY_START

TEXT

The START value from CREATE TABLE ... (columnX ... AUTOINCREMENT START <#> ...).

IDENTITY_INCREMENT

TEXT

The INCREMENT value from CREATE TABLE ... (columnX ... AUTOINCREMENT INCREMENT <#> ...).

IDENTITY_MAXIMUM

TEXT

Not applicable for Snowflake.

IDENTITY_MINIMUM

TEXT

Not applicable for Snowflake.

IDENTITY_CYCLE

TEXT

Whether the value of an identity column may cycle. Snowflake only supports NO CYCLE.

COMMENT

TEXT

Comment for this column

Usage Notes

  • The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command when both are executed by a user who holds the MANAGE GRANTS privilege.