16.20 - HELP storage_format SCHEMA - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Purpose

Displays the name of a schema, the storage format of the DATASET type associated with the schema, and the length of the schema. The length is listed in UNICODE characters.

Privileges

None.

Syntax



Syntax Elements

storage_format
Storage format of the DATASET type for the schema.
SYSUDTLIB
Database containing the schema.
schema_name
Name of the schema.

Example

This example displays the HELP information for the schema from the CREATE storage_format SCHEMA example:

     HELP Avro SCHEMA chemDatasetSchema;
               SchemaName chemDatasetSchema
            StorageFormat Avro
                   Length 201