Variable Schema Formats - Advanced SQL Engine - Teradata Database

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
des1556232910526.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1198
lifecycle
previous
Product Category
Teradata Vantageā„¢

The DATASET data type may be associated with any known schema. You can provide a schema based on frequently used structures, which are stored in the Data Dictionary. All DATASET functionality is available to storage formats using any schema that conforms to specifications for that storage format. After it is registered, any schema can be referenced using the WITH SCHEMA <name> clause.

You cannot specify the WITH SCHEMA option when creating a volatile table.

No built-in schemas are provided for use with DATASET, in any of its storage formats.