René's URL Explorer Experiment


Title: Strukturierte Datentypen | Snowflake Documentation

direct link

Domain: docs.snowflake.com

Links:

DOCUMENTATIONhttps://docs.snowflake.com
Englishhttps://docs.snowflake.com/en/sql-reference/data-types-structured
Françaishttps://docs.snowflake.com/fr/sql-reference/data-types-structured
Deutschhttps://docs.snowflake.com/de/sql-reference/data-types-structured
日本語https://docs.snowflake.com/ja/sql-reference/data-types-structured
한국어https://docs.snowflake.com/ko/sql-reference/data-types-structured
Portuguêshttps://docs.snowflake.com/pt/sql-reference/data-types-structured
Erste Schrittehttps://docs.snowflake.com/de/user-guide-getting-started
Benutzerhandbücherhttps://docs.snowflake.com/de/guides
Entwicklerhttps://docs.snowflake.com/de/developer
Referenzhttps://docs.snowflake.com/de/reference
Versionshinweisehttps://docs.snowflake.com/de/release-notes/overview
Tutorialshttps://docs.snowflake.com/de/tutorials
Statushttps://status.snowflake.com
Überblickhttps://docs.snowflake.com/de/reference
Referenz der SQL-Datentypenhttps://docs.snowflake.com/de/sql-reference-data-types
Zusammenfassunghttps://docs.snowflake.com/de/sql-reference/intro-summary-data-types
Numerischhttps://docs.snowflake.com/de/sql-reference/data-types-numeric
Zeichenfolgen- und Binärdatenhttps://docs.snowflake.com/de/sql-reference/data-types-text
Logischhttps://docs.snowflake.com/de/sql-reference/data-types-logical
Datum und Uhrzeithttps://docs.snowflake.com/de/sql-reference/data-types-datetime
Semistrukturierthttps://docs.snowflake.com/de/sql-reference/data-types-semistructured
Strukturierthttps://docs.snowflake.com/de/sql-reference/data-types-structured
Unstrukturierthttps://docs.snowflake.com/de/sql-reference/data-types-unstructured
Geofunktionenhttps://docs.snowflake.com/de/sql-reference/data-types-geospatial
UUIDhttps://docs.snowflake.com/de/sql-reference/data-types-uuid
Vektorhttps://docs.snowflake.com/de/sql-reference/data-types-vector
User-definedhttps://docs.snowflake.com/de/sql-reference/data-types-user-defined
Nicht unterstützthttps://docs.snowflake.com/de/sql-reference/data-types-unsupported
Konvertierunghttps://docs.snowflake.com/de/sql-reference/data-type-conversion
Referenz zu SQL-Befehlenhttps://docs.snowflake.com/de/sql-reference-commands
Referenz für Funktionen und gespeicherte Prozedurenhttps://docs.snowflake.com/de/sql-reference-functions
Klassenreferenzhttps://docs.snowflake.com/de/sql-reference-classes
Scripting-Referenzhttps://docs.snowflake.com/de/sql-reference-snowflake-scripting
Allgemeine Referenzhttps://docs.snowflake.com/de/sql-reference
API-Referenzhttps://docs.snowflake.com/de/api-reference
Referenzhttps://docs.snowflake.com/de/reference
Referenz der SQL-Datentypenhttps://docs.snowflake.com/de/sql-reference-data-types
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#structured-data-types
Snowflake-Datentypenhttps://docs.snowflake.com/de/sql-reference-data-types
Apache Iceberg™-Tabellehttps://docs.snowflake.com/de/user-guide/tables-iceberg
Apache Iceberg™-Datentypenhttps://docs.snowflake.com/de/user-guide/tables-iceberg-data-types
ARRAYhttps://docs.snowflake.com/de/sql-reference/data-types-semistructured.html#label-data-type-array
OBJECThttps://docs.snowflake.com/de/sql-reference/data-types-semistructured.html#label-data-type-object
VARIANThttps://docs.snowflake.com/de/sql-reference/data-types-semistructured.html#label-data-type-variant
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#specifying-a-structured-type
Festlegen eines strukturierten ARRAY-Typshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-specifying-array
Festlegen eines strukturierten OBJECT-Typshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-specifying-object
Festlegen eines MAP-Typshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-specifying-map
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#specifying-a-structured-array-type
Snowflake-Datentyphttps://docs.snowflake.com/de/sql-reference-data-types
SYSTEM$TYPEOFhttps://docs.snowflake.com/de/sql-reference/functions/system_typeof
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#specifying-a-structured-object-type
Snowflake-Datentyphttps://docs.snowflake.com/de/sql-reference-data-types
SYSTEM$TYPEOFhttps://docs.snowflake.com/de/sql-reference/functions/system_typeof
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#specifying-a-map-type
Snowflake-Datentyphttps://docs.snowflake.com/de/sql-reference-data-types
Snowflake-Datentyphttps://docs.snowflake.com/de/sql-reference-data-types
SYSTEM$TYPEOFhttps://docs.snowflake.com/de/sql-reference/functions/system_typeof
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#creating-a-table-with-a-structured-type-column
CREATE TABLEhttps://docs.snowflake.com/de/sql-reference/sql/create-table
Festlegen eines strukturierten Typshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-specifying
Beispiel für die Erstellung einer Tabelle mit einer strukturierten ARRAY-Spaltehttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-cols-create-table-array
Beispiel für die Erstellung einer Tabelle mit einer strukturierten OBJECT-Spaltehttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-cols-create-table-object
Beispiel für die Erstellung einer Tabelle mit einer MAP-Spaltehttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-cols-create-table-map
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#example-of-creating-a-table-with-a-structured-array-column
ARRAY-Konstantehttps://docs.snowflake.com/de/sql-reference/data-types-semistructured.html#label-array-constant
OBJECT_CONSTRUCThttps://docs.snowflake.com/de/sql-reference/functions/object_construct
ARRAY_CONSTRUCThttps://docs.snowflake.com/de/sql-reference/functions/array_construct
nichthttps://docs.snowflake.com/de/sql-reference/sql/insert.html#label-insert-command-usage-notes
eine ARRAY-Konstante ein semistrukturiertes ARRAY (nicht ein strukturiertes ARRAY)https://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-constructing-constants
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#example-of-creating-a-table-with-a-structured-object-column
OBJECT-Konstantehttps://docs.snowflake.com/de/sql-reference/data-types-semistructured.html#label-object-constant
OBJECT_CONSTRUCThttps://docs.snowflake.com/de/sql-reference/functions/object_construct
ARRAY_CONSTRUCThttps://docs.snowflake.com/de/sql-reference/functions/array_construct
nichthttps://docs.snowflake.com/de/sql-reference/sql/insert.html#label-insert-command-usage-notes
eine OBJECT-Konstante ein semistrukturiertes OBJECT (nicht ein strukturiertes OBJECT)https://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-constructing-constants
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#example-of-creating-a-table-with-a-map-column
OBJECT-Konstantehttps://docs.snowflake.com/de/sql-reference/data-types-semistructured.html#label-object-constant
OBJECT_CONSTRUCThttps://docs.snowflake.com/de/sql-reference/functions/object_construct
ARRAY_CONSTRUCThttps://docs.snowflake.com/de/sql-reference/functions/array_construct
nichthttps://docs.snowflake.com/de/sql-reference/sql/insert.html#label-insert-command-usage-notes
eine OBJECT-Konstante ein semistrukturiertes OBJECT (nicht eine MAP)https://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-constructing-constants
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#adding-a-structured-type-column
ALTER TABLE … ADD COLUMNhttps://docs.snowflake.com/de/sql-reference/sql/alter-table
Festlegen eines strukturierten Typshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-specifying
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#dropping-and-renaming-structured-type-columns
ALTER TABLE … DROP COLUMNhttps://docs.snowflake.com/de/sql-reference/sql/alter-table
ALTER TABLE … RENAME COLUMNhttps://docs.snowflake.com/de/sql-reference/sql/alter-table
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-structured-types-in-semi-structured-types
OBJECT-Konstantehttps://docs.snowflake.com/de/sql-reference/data-types-semistructured.html#label-object-constant
ARRAY-Konstantehttps://docs.snowflake.com/de/sql-reference/data-types-semistructured.html#label-array-constant
Konstruktorfunktionhttps://docs.snowflake.com/de/sql-reference/functions-semistructured
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#converting-structured-and-semi-structured-types
Konvertierenhttps://docs.snowflake.com/de/sql-reference/data-type-conversion
Umwandlunghttps://docs.snowflake.com/de/sql-reference/data-type-conversion.html#label-data-type-explicit-casting
Koersionhttps://docs.snowflake.com/de/sql-reference/data-type-conversion.html#label-when-coercion-occurs
Explizites Umwandeln eines semistrukturierten Typs in einen strukturierten Typhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-semi-object
Explizites Umwandeln eines strukturierten Typs in einen semistrukturierten Typhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-structured
Implizites Umwandeln eines Wertes (Koersion)https://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-implicit
Umwandeln von einem strukturierten Typ in einen anderenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-struct-struct
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#explicitly-casting-a-semi-structured-type-to-a-structured-type
die Funktion CAST aufrufen oder den :: Operatorhttps://docs.snowflake.com/de/sql-reference/functions/cast
Umwandeln von semistrukturierten ARRAY- und VARIANT-Werten in strukturierte ARRAY-Wertehttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-semi-object-array
Umwandeln von semistrukturierten OBJECT- und VARIANT-Werten in strukturierte OBJECT-Wertehttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-semi-object-object
Umwandeln von semistrukturierten OBJECT- und VARIANT-Werten in MAP-Wertehttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-semi-object-map
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#casting-semi-structured-array-and-variant-values-to-structured-array-values
JSON-Nullwertehttps://docs.snowflake.com/de/user-guide/semistructured-considerations.html#label-variant-null
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#casting-semi-structured-object-and-variant-values-to-structured-object-values
JSON-Nullwerthttps://docs.snowflake.com/de/user-guide/semistructured-considerations.html#label-variant-null
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#casting-semi-structured-object-and-variant-values-to-map-values
JSON-Nullwerthttps://docs.snowflake.com/de/user-guide/semistructured-considerations.html#label-variant-null
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#explicitly-casting-a-structured-type-to-a-semi-structured-type
die Funktion CAST aufrufen, den :: Operatorhttps://docs.snowflake.com/de/sql-reference/functions/cast
TO_ARRAYhttps://docs.snowflake.com/de/sql-reference/functions/to_array
TO_OBJECThttps://docs.snowflake.com/de/sql-reference/functions/to_object
TO_VARIANThttps://docs.snowflake.com/de/sql-reference/functions/to_variant
JSON-Nullwertehttps://docs.snowflake.com/de/user-guide/semistructured-considerations.html#label-variant-null
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#implicit-casting-a-value-coercion
implizites Umwandeln (Koersion)https://docs.snowflake.com/de/sql-reference/data-type-conversion.html#label-when-coercion-occurs
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#casting-from-one-structured-type-to-another
die Funktion CAST aufrufen oder den :: Operatorhttps://docs.snowflake.com/de/sql-reference/functions/cast
Sie können einen ARRAY-Wert eines Typs in einen ARRAY-Wert eines anderen Typshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-struct-struct-array-types
die Reihenfolge der Schlüssel-Wert-Paarehttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-struct-struct-object-key-order
eine Änderung des Namens der Schlüsselhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-struct-struct-object-key-names
Schlüsselhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-struct-struct-object-key-add
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#example-casting-from-one-type-of-array-value-to-another
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#example-changing-the-order-of-key-value-pairs-in-an-object-value
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#example-changing-the-key-names-in-an-object-value
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#example-adding-keys-to-an-object-value
OBJECT_INSERThttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-transform-object-insert
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#constructing-structured-array-structured-object-and-map-values
Verwenden von SQL-Funktionen zum Erstellen von strukturierten ARRAY- und OBJECT-Wertenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-constructing-functions
Verwenden von ARRAY- und OBJECT-Konstanten zum Erstellen von strukturierten ARRAY- und OBJECT-Wertenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-constructing-constants
Erstellen eines MAP-Wertshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-constructing-map
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-sql-functions-to-construct-structured-array-and-object-values
ARRAY_CONSTRUCThttps://docs.snowflake.com/de/sql-reference/functions/array_construct
ARRAY_CONSTRUCT_COMPACThttps://docs.snowflake.com/de/sql-reference/functions/array_construct_compact
ARRAY_AGGhttps://docs.snowflake.com/de/sql-reference/functions/array_agg
TO_ARRAYhttps://docs.snowflake.com/de/sql-reference/functions/to_array
OBJECT_CONSTRUCThttps://docs.snowflake.com/de/sql-reference/functions/object_construct
OBJECT_CONSTRUCT_KEEP_NULLhttps://docs.snowflake.com/de/sql-reference/functions/object_construct_keep_null
OBJECT_AGGhttps://docs.snowflake.com/de/sql-reference/functions/object_agg
TO_OBJECThttps://docs.snowflake.com/de/sql-reference/functions/to_object
Explizites Umwandeln eines semistrukturierten Typs in einen strukturierten Typhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-semi-object
Implizites Umwandeln eines Wertes (Koersion)https://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-implicit
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-array-and-object-constants-to-construct-structured-array-and-object-values
ARRAY-Konstantehttps://docs.snowflake.com/de/sql-reference/data-types-semistructured.html#label-array-constant
OBJECT-Konstantehttps://docs.snowflake.com/de/sql-reference/data-types-semistructured.html#label-object-constant
Explizites Umwandeln eines semistrukturierten Typs in einen strukturierten Typhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-semi-object
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#constructing-a-map-value
Umwandeln von semistrukturierten OBJECT- und VARIANT-Werten in MAP-Wertehttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-semi-object-map
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#working-with-keys-values-and-elements-in-values-of-structured-types
Abrufen der Liste der Schlüssel aus einem strukturierten OBJECT-Werthttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-kv-elem-key-list
Abrufen der Liste von Schlüsseln aus einem MAP-Werthttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-kv-elem-key-list-map
Zugriff auf Werte und Elemente aus Werten von strukturierten Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-kv-elem-val-access
Bestimmen der Größe eines strukturierten ARRAY-Wertshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-kv-elem-size
Bestimmen der Größe eines MAP-Wertshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-kv-elem-size-map
Suchen von Elementen in einem strukturierten ARRAY-Werthttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-kv-elem-lookup
Feststellen, ob ein MAP-Wert einen Schlüssel enthälthttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-kv-elem-key
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#getting-the-list-of-keys-from-a-structured-object-value
OBJECT_KEYShttps://docs.snowflake.com/de/sql-reference/functions/object_keys
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#getting-the-list-of-keys-from-a-map-value
MAP_KEYShttps://docs.snowflake.com/de/sql-reference/functions/map_keys
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#accessing-values-and-elements-from-values-of-structured-types
GEThttps://docs.snowflake.com/de/sql-reference/functions/get
GET_IGNORE_CASEhttps://docs.snowflake.com/de/sql-reference/functions/get_ignore_case
GET_PATHhttps://docs.snowflake.com/de/sql-reference/functions/get_path
Punktierte Schreibweisehttps://docs.snowflake.com/de/user-guide/querying-semistructured.html#label-querying-semistructured-data-dot-notation
Klammernotationhttps://docs.snowflake.com/de/user-guide/querying-semistructured.html#label-bracket-notation-when-querying-semistructured-data
SYSTEM$TYPEOFhttps://docs.snowflake.com/de/sql-reference/functions/system_typeof
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#determining-the-size-of-a-structured-array-value
ARRAY_SIZEhttps://docs.snowflake.com/de/sql-reference/functions/array_size
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#determining-the-size-of-a-map-value
MAP_SIZEhttps://docs.snowflake.com/de/sql-reference/functions/map_size
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#looking-up-elements-in-a-structured-array-value
ARRAY_CONTAINShttps://docs.snowflake.com/de/sql-reference/functions/array_contains
ARRAY_POSITIONhttps://docs.snowflake.com/de/sql-reference/functions/array_position
, der mit dem Typ des ARRAY-Werts vergleichbar isthttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-compare
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#determining-if-a-map-value-contains-a-key
MAP_CONTAINS_KEYhttps://docs.snowflake.com/de/sql-reference/functions/map_contains_key
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#comparing-values
Vergleich von strukturierten Werten mit semistrukturierten Wertenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-compare-struct-semi
Vergleich von strukturierten Werten mit anderen strukturierten Wertenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-compare-struct-struct
Feststellen, ob sich zwei ARRAY-Werte überlappenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-compare-array-overlap
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#comparing-structured-values-with-semi-structured-values
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#comparing-structured-values-with-other-structured-values
implizit in den anderen Typ umgewandelthttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-implicit
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#determining-if-two-array-values-overlap
ARRAYS_OVERLAPhttps://docs.snowflake.com/de/sql-reference/functions/arrays_overlap
vergleichbaren Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-compare-struct-struct
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#transforming-values-of-structured-types
Transformieren von strukturierten ARRAY-Wertenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-transform-array
Transformieren von strukturierten OBJECT-Wertenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-transform-object
Transformieren von MAP-Wertenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-transform-map
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#transforming-structured-array-values
ARRAY_APPENDhttps://docs.snowflake.com/de/sql-reference/functions/array_append
ARRAY_CAThttps://docs.snowflake.com/de/sql-reference/functions/array_cat
ARRAY_COMPACThttps://docs.snowflake.com/de/sql-reference/functions/array_compact
ARRAY_EXCEPThttps://docs.snowflake.com/de/sql-reference/functions/array_except
ARRAY_INSERThttps://docs.snowflake.com/de/sql-reference/functions/array_insert
ARRAY_INTERSECTIONhttps://docs.snowflake.com/de/sql-reference/functions/array_intersection
ARRAY_PREPENDhttps://docs.snowflake.com/de/sql-reference/functions/array_prepend
ARRAY_SLICEhttps://docs.snowflake.com/de/sql-reference/functions/array_slice
ARRAY_UNION_AGGhttps://docs.snowflake.com/de/sql-reference/functions/array_union_agg
Funktionen, die Elemente zu ARRAY-Werten hinzufügenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-transform-array-add-elements
Funktionen, die mehrere ARRAY-Werte als Eingabe akzeptierenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-transform-array-multiple
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#functions-that-add-elements-to-array-values
ARRAY_APPENDhttps://docs.snowflake.com/de/sql-reference/functions/array_append
ARRAY_INSERThttps://docs.snowflake.com/de/sql-reference/functions/array_insert
ARRAY_PREPENDhttps://docs.snowflake.com/de/sql-reference/functions/array_prepend
implizit umwandelbar (Koersion)https://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-implicit
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#functions-that-accept-multiple-array-values-as-input
ARRAY_CAThttps://docs.snowflake.com/de/sql-reference/functions/array_cat
ARRAY_EXCEPThttps://docs.snowflake.com/de/sql-reference/functions/array_except
ARRAY_INTERSECTIONhttps://docs.snowflake.com/de/sql-reference/functions/array_intersection
in den Typ des ersten Argumentshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-implicit
vergleichbar seinhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-compare-struct-struct
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#transforming-structured-object-values
Entfernen von Schlüssel-Wert-Paarenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-transform-object-delete
Einfügen von Schlüssel-Wert-Paaren und Aktualisieren von Wertenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-transform-object-insert
Auswählen von Schlüssel-Wert-Paaren aus einem bestehenden OBJECThttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-transform-object-pick
CAST oder den Operator ::https://docs.snowflake.com/de/sql-reference/functions/cast
Umwandeln von einem strukturierten Typ in einen anderenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-struct-struct
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#removing-key-value-pairs
OBJECT_DELETEhttps://docs.snowflake.com/de/sql-reference/functions/object_delete
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#inserting-key-value-pairs-and-updating-values
OBJECT_INSERThttps://docs.snowflake.com/de/sql-reference/functions/object_insert
implizit umgewandelt (Koersion)https://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-implicit
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#selecting-key-value-pairs-from-an-existing-object
OBJECT_PICKhttps://docs.snowflake.com/de/sql-reference/functions/object_pick
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#transforming-map-values
MAP_CAThttps://docs.snowflake.com/de/sql-reference/functions/map_cat
MAP_DELETEhttps://docs.snowflake.com/de/sql-reference/functions/map_delete
MAP_INSERThttps://docs.snowflake.com/de/sql-reference/functions/map_insert
MAP_PICKhttps://docs.snowflake.com/de/sql-reference/functions/map_pick
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#working-with-structured-types
Verwenden der Funktion FLATTEN mit Werten von strukturierten Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-working-flatten
Verwenden der Funktion PARSE_JSONhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-working-parse-json
Verwenden strukturierter Typen mit Mengenoperatoren und CASE-Ausdrückenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-working-set-operators
Arbeiten mit anderen semistrukturierten Funktionenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-working-other-functions
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-the-flatten-function-with-values-of-structured-types
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-the-parse-json-function
PARSE_JSONhttps://docs.snowflake.com/de/sql-reference/functions/parse_json
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-structured-types-with-set-operators-and-case-expressions
Durch Mengenoperatoren kombinierte Abfrageausdrücke (z. B. UNION ALL)https://docs.snowflake.com/de/sql-reference/operators-query
CASE-Ausdrückehttps://docs.snowflake.com/de/sql-reference/functions/case
implizit umgewandelthttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-casting-implicit
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#working-with-other-semi-structured-functions
AS_ARRAYhttps://docs.snowflake.com/de/sql-reference/functions/as_array
AS_OBJECThttps://docs.snowflake.com/de/sql-reference/functions/as_object
IS_ARRAYhttps://docs.snowflake.com/de/sql-reference/functions/is_array
IS_OBJECThttps://docs.snowflake.com/de/sql-reference/functions/is_object
TYPEOFhttps://docs.snowflake.com/de/sql-reference/functions/typeof
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#accessing-structured-types-in-applications-using-drivers
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-structured-types-with-user-defined-functions-udfs-and-stored-procedures
SQLhttps://docs.snowflake.com/de/developer-guide/udf/sql/udf-sql-introduction
Snowflake Scriptinghttps://docs.snowflake.com/de/developer-guide/stored-procedure/stored-procedures-snowflake-scripting
Javahttps://docs.snowflake.com/de/developer-guide/udf/java/udf-java-introduction
Pythonhttps://docs.snowflake.com/de/developer-guide/udf/python/udf-python-introduction
Scalahttps://docs.snowflake.com/de/developer-guide/udf/scala/udf-scala-introduction
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#viewing-information-about-structured-types
Verwenden des Befehls SHOW COLUMNS zum Anzeigen strukturierter Typinformationenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-info-show-cols
Verwenden der DESCRIBE- und anderer SHOW-Befehle zum Anzeigen von Informationen zu strukturierten Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-info-desc-show
Anzeigen von Informationen zu den in einer Datenbank verwendeten strukturierten Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#label-structured-types-info-views
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-the-show-columns-command-to-view-structured-type-information
SHOW COLUMNShttps://docs.snowflake.com/de/sql-reference/sql/show-columns
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-the-describe-and-other-show-commands-to-view-structured-type-information
DESCRIBE TABLEhttps://docs.snowflake.com/de/sql-reference/sql/desc-table
DESCRIBE RESULThttps://docs.snowflake.com/de/sql-reference/sql/desc-result
DESCRIBE FUNCTIONhttps://docs.snowflake.com/de/sql-reference/sql/desc-function
DESCRIBE PROCEDUREhttps://docs.snowflake.com/de/sql-reference/sql/desc-procedure
SHOW FUNCTIONShttps://docs.snowflake.com/de/sql-reference/sql/show-functions
SHOW PROCEDUREShttps://docs.snowflake.com/de/sql-reference/sql/show-procedures
https://docs.snowflake.com/de/sql-reference/data-types-structured.html#viewing-information-about-the-structured-types-used-in-a-database
Ansicht COLUMNShttps://docs.snowflake.com/de/sql-reference/info-schema/columns
ELEMENT_TYPES in INFORMATION_SCHEMAhttps://docs.snowflake.com/de/sql-reference/info-schema/element_types
ELEMENT_TYPES in ACCOUNT_USAGEhttps://docs.snowflake.com/de/sql-reference/account-usage/element_types
FIELDS-Ansicht in INFORMATION_SCHEMAhttps://docs.snowflake.com/de/sql-reference/info-schema/fields
FIELDS-Ansicht in ACCOUNT_USAGEhttps://docs.snowflake.com/de/sql-reference/account-usage/fields
Besuchen Sie Snowflakehttps://www.snowflake.com
An Diskussion beteiligenhttps://community.snowflake.com/s/
Mit Snowflake entwickelnhttps://developers.snowflake.com
Teilen Sie Ihr Feedback mithttps://docs.snowflake.com/feedback
Lesen Sie Neuigkeiten in unserem Bloghttps://www.snowflake.com/blog/
Eigene Zertifizierung erhaltenhttps://learn.snowflake.com
Datenschutzhttps://www.snowflake.com/privacy-policy/
Nutzungsbedingungenhttps://www.snowflake.com/legal/snowflake-site-terms/
Snowflake Python APIshttps://docs.snowflake.com/developer-guide/snowflake-python-api/snowflake-python-overview
Snowflake REST APIshttps://docs.snowflake.com/developer-guide/snowflake-rest-api/snowflake-rest-api
Snowflake CLIhttps://docs.snowflake.com/developer-guide/snowflake-cli/index
Festlegen eines strukturierten Typshttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#specifying-a-structured-type
Tabelle mit einer Spalte mit strukturiertem Typ erstellenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#creating-a-table-with-a-structured-type-column
Spalte mit strukturiertem Typ hinzufügenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#adding-a-structured-type-column
Spalten mit strukturiertem Typ löschen und umbenennenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#dropping-and-renaming-structured-type-columns
Verwenden von strukturierten Typen in semistrukturierten Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-structured-types-in-semi-structured-types
Konvertieren strukturierter und semistrukturierter Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#converting-structured-and-semi-structured-types
Erstellen von strukturierten ARRAY-, strukturierten OBJECT- und MAP- Wertenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#constructing-structured-array-structured-object-and-map-values
Verwenden von Schlüsseln, Werten und Elementen in Werten von strukturierten Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#working-with-keys-values-and-elements-in-values-of-structured-types
Werte vergleichenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#comparing-values
Transformieren von Werten strukturierter Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#transforming-values-of-structured-types
Verwenden von strukturierten Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#working-with-structured-types
Zugriff auf strukturierte Typen in Anwendungen mit Treibernhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#accessing-structured-types-in-applications-using-drivers
Verwenden strukturierter Typen mit benutzerdefinierten Funktionen (UDFs) und gespeicherten Prozedurenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#using-structured-types-with-user-defined-functions-udfs-and-stored-procedures
Anzeigen von Informationen zu strukturierten Typenhttps://docs.snowflake.com/de/sql-reference/data-types-structured.html#viewing-information-about-structured-types

Viewport: width=device-width

URLs of crawlers that visited me.