EXPORTWIDTH - 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

The system uses the value you assign to a user as a NUPI to access DBC.ExportWidth, which defines the rules associated with the different export width definitions for Latin, Unicode, KanjiSJIS, and Graphic strings. For more information about DBC.ExportWidth, see Data Dictionary, B035-1092.

export_definition_name
Export width for this user, enclosed in SINGLE QUOTATION MARK characters.
Teradata Database supports the keyword DEFAULT as an export width definition string as well as the following predefined export width definition strings.
  • COMPATIBILITY
  • EXPECTED
  • MAXIMUM
For a detailed description of the valid export width specifications, see Valid Export Width Specifications.
For detailed information about export widths and how to define your own export width table, see International Character Set Support, B035-1125.
DEFAULT
If you do not specify an EXPORTWIDTH value for a user or specify the keyword DEFAULT, the system uses the export width currently specified by the DBSControl Export Width Table ID parameter. See Export Width Table ID in Database Utilities, B035-1102.