The DATASET data type uses the SQL data definition language (DDL) statement, SET SESSION DOT NOTATION.
The DATASET data type enhanced the following statements:
- CREATE TABLE
- ALTER TABLE
- CREATE/REPLACE function
- CREATE storage_format SCHEMA
- SHOW storage_format SCHEMA
- DROP storage_format SCHEMA
- HELP storage_format SCHEMA
- CREATE INDEX
- COLLECT STATISTICS
- HELP, SHOW, and TYPE commands
For more information, see Teradata Vantageā¢ - SQL Data Definition Language Syntax and Examples, B035-1144.