17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

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

The DBC.DatasetSchemaInfo table is used to register schema definitions created by the CREATE SCHEMA statement. The DatasetSchemaInfoV view allows users to get information about registered schemas from the table.

Possible Values for StorageFormat

StorageFormat specifies the storage format of any column with multiple storage formats.

Value Description
AVRO Column contains DATASET content stored in AVRO format.
CSV Column contains DATASET content stored in CSV format.
NULL The column does not have multiple storage formats.