17.10 - NameValidationRule - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Determines whether additional rules are used by Vantage to validate object names.

Field Group

General

Valid Settings

Setting Description
0 No additional name validation is performed beyond basic validation rules.
1 Name validation rules used in pre-14.10 releases.
2 Name validation using a minimal character set:

'A' - 'Z', 'a' - 'z', '0' - '9', '#', '$', and '_'

62 Name validation using the UTF16 client character set.
63 Name validation using the UTF8 client character set.
64 Name validation using the EBCDIC client character set.
65 through 126 Name validation using a user-defined character set.
127 Name validation using the ASCII client character set.

Default

0

Changes Take Effect

After the next database restart for new objects. Objects created prior to changing this setting are unaffected by the change.

Related Information

For more information on... See...
Basic object naming rules Teradata Vantage™ - SQL Fundamentals, B035-1141.
User-defined character sets Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.