15.00 - Name and Title Size Limits - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Name and Title Size Limits

 

Parameter

Value

Maximum name size for database objects, for example, account, attribute, authorization, column, constraint, database, function, GLOP, index, macro, method, parameter, password, plan directive, procedure, profile, proxy user, query, role, stored procedure, table, transform group, trigger, UDF, UDM, UDT, using variable name, view.

See SQL Fundamentals for other applicable naming rules.

Depends on the setting of the DBS Control parameter EnableEON:

  • 30 bytes, if EnableEON = no
  • 128 UNICODE characters, if EnableEON = yes
  • Maximum system name size

    Used in SQL statements for target level emulation. See SQL Data Manipulation Language.

    Depends on the setting of the DBS Control parameter EnableEON:

  • 30 characters, if EnableEON = no
  • 63 characters, if EnableEON = yes
  • Maximum SQL text title size.

    Depends on the setting of the DBS Control EnableEON field:

  • 60 characters, if EnableEON = no
  • 256 characters, if EnableEON = yes