DATASET_KEYS Operator | DATASET Data Type | Teradata Vantage - 17.05 - DATASET_KEYS - Teradata Database

Teradata Vantageā„¢ - DATASET Data Type

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1198-170K

The DATASET_KEYS table operator provides a list of all keys that can be queried in a DATASET data type instance, or a DATASET schema specified as CHAR/VARCHAR/CLOB/JSON.

Syntax

DATASET_KEYS ( ON
  ( SELECT DATASET_expression select_stmt_options )
  [ USING QUOTES ( { 'Y' | 'N' } ) ]
)