ELEMENT_TYPES view

This Information Schema view displays a row for each structured ARRAY type in an object (a column in a table) in the specified (or current) database.

Each row describes the type of the element in the structured ARRAY.

Columns

Column Name

Data Type

Description

OBJECT_CATALOG

VARCHAR

Database that contains the object that uses this ARRAY type.

OBJECT_SCHEMA

VARCHAR

Schema that contains the object that uses this ARRAY type.

OBJECT_NAME

VARCHAR

Name of the object that uses this ARRAY type (e.g. name of a table).

OBJECT_TYPE

VARCHAR

Type of the object that uses this ARRAY type:

  • TABLE (if used by a column)

COLLECTION_TYPE_IDENTIFIER

VARCHAR

Type identifier. Use this to join on:

  • The DTD_IDENTIFIER column in the COLUMNS view.

  • The DTD_IDENTIFIER column in this view (for nested types).

  • The DTD_IDENTIFIER column in the FIELDS view (for nested types).

DATA_TYPE

VARCHAR

Data type of the element.

CHARACTER_MAXIMUM_LENGTH

NUMBER

Maximum length in characters of string elements.

CHARACTER_OCTET_LENGTH

NUMBER

Maximum length in bytes of string elements.

NUMERIC_PRECISION

NUMBER

Numeric precision of numeric elements.

NUMERIC_PRECISION_RADIX

NUMBER

Radix of precision of numeric elements.

NUMERIC_SCALE

NUMBER

Scale of numeric elements.

DATETIME_PRECISION

NUMBER

Not applicable for Snowflake.

INTERVAL_TYPE

VARCHAR

Not applicable for Snowflake.

INTERVAL_PRECISION

NUMBER

Not applicable for Snowflake.

CHARACTER_SET_CATALOG

VARCHAR

Not applicable for Snowflake.

CHARACTER_SET_SCHEMA

VARCHAR

Not applicable for Snowflake.

CHARACTER_SET_NAME

VARCHAR

Not applicable for Snowflake.

COLLATION_CATALOG

VARCHAR

Not applicable for Snowflake.

COLLATION_SCHEMA

VARCHAR

Not applicable for Snowflake.

COLLATION_NAME

VARCHAR

The collation specification for this element

UDT_CATALOG

VARCHAR

Not applicable for Snowflake.

UDT_SCHEMA

VARCHAR

Not applicable for Snowflake.

UDT_NAME

VARCHAR

Not applicable for Snowflake.

SCOPE_CATALOG

VARCHAR

Not applicable for Snowflake.

SCOPE_SCHEMA

VARCHAR

Not applicable for Snowflake.

SCOPE_NAME

VARCHAR

Not applicable for Snowflake.

MAXIMUM_CARDINALITY

NUMBER

Maximum cardinality. Currently, this is always set to NULL.

DTD_IDENTIFIER

VARCHAR

Nested type identifier. Use this to join on:

  • The COLLECTION_TYPE_IDENTIFIER column in this view.

  • The ROW_IDENTIFIER column in the FIELDS view (for nested types).

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 the SHOW COLUMNS command when both are executed by a user who holds the MANAGE GRANTS privilege.