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 Not applicable for Snowflake.
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 Not applicable for Snowflake.
IDENTITY_INCREMENT TEXT Not applicable for Snowflake.
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.