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.