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).
OBJECT_ID
VARCHAR
Internal/system-generated identifier for the object that uses this ARRAY type (e.g. name of a table).
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)
OBJECT_SCHEMA_ID
VARCHAR
Internal/system-generated identifier for the schema of the object that uses this ARRAY type.
OBJECT_SCHEMA
VARCHAR
Schema that contains the object that uses this ARRAY type.
OBJECT_CATALOG_ID
VARCHAR
Internal/system-generated identifier for the database of the object that uses this ARRAY type.
OBJECT_CATALOG
VARCHAR
Database that contains the object that uses this ARRAY type.
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).
IS_NULLABLE
VARCHAR
Y if the structured ARRAY allows NULL values; N otherwise.
DELETED
TIMESTAMP_LTZ
Date and time when the object was dropped.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4