DEFAULT Mode - Teradata Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Database
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-09-23
dita:mapPath
mbm1747160743883.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
dita:id
mdr1472255012272
lifecycle
latest

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, the system assigns the export definition that is currently defined in the Export Width Table ID parameter of DBS Control to that user (see Database Utilities, B035-1102 for further information).