17.00 - DEFAULT Mode - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
September 2020
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

Unlike Compatibility, Expected, and Maximum modes, which are literal strings that represent predefined export width definitions, DEFAULT is an SQL keyword that does not have a predefined meaning and is not delimited by SINGLE QUOTATION MARK characters.

If you specify DEFAULT as the Export Width for a user, Vantage assigns the export definition that is currently defined in the Export Width Table ID parameter of DBS Control to that user (see Teradata Vantage™ - Database Utilities , B035-1102 for further information).