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 NameData TypeDescription
OBJECT_CATALOGVARCHARDatabase that contains the object that uses this ARRAY type.
OBJECT_SCHEMAVARCHARSchema that contains the object that uses this ARRAY type.
OBJECT_NAMEVARCHARName of the object that uses this ARRAY type (e.g. name of a table).
OBJECT_TYPEVARCHAR

Type of the object that uses this ARRAY type:

  • TABLE (if used by a column)
COLLECTION_TYPE_IDENTIFIERVARCHAR

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_TYPEVARCHARData type of the element.
CHARACTER_MAXIMUM_LENGTHNUMBERMaximum length in characters of string elements.
CHARACTER_OCTET_LENGTHNUMBERMaximum length in bytes of string elements.
NUMERIC_PRECISIONNUMBERNumeric precision of numeric elements.
NUMERIC_PRECISION_RADIXNUMBERRadix of precision of numeric elements.
NUMERIC_SCALENUMBERScale of numeric elements.
DATETIME_PRECISIONNUMBERNot applicable for Snowflake.
INTERVAL_TYPEVARCHARNot applicable for Snowflake.
INTERVAL_PRECISIONNUMBERNot applicable for Snowflake.
CHARACTER_SET_CATALOGVARCHARNot applicable for Snowflake.
CHARACTER_SET_SCHEMAVARCHARNot applicable for Snowflake.
CHARACTER_SET_NAMEVARCHARNot applicable for Snowflake.
COLLATION_CATALOGVARCHARNot applicable for Snowflake.
COLLATION_SCHEMAVARCHARNot applicable for Snowflake.
COLLATION_NAMEVARCHARThe collation specification for this element
UDT_CATALOGVARCHARNot applicable for Snowflake.
UDT_SCHEMAVARCHARNot applicable for Snowflake.
UDT_NAMEVARCHARNot applicable for Snowflake.
SCOPE_CATALOGVARCHARNot applicable for Snowflake.
SCOPE_SCHEMAVARCHARNot applicable for Snowflake.
SCOPE_NAMEVARCHARNot applicable for Snowflake.
MAXIMUM_CARDINALITYNUMBERMaximum cardinality. Currently, this is always set to NULL.
DTD_IDENTIFIERVARCHAR

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.