15.00 - Valid Characters in Object Names - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Valid Characters in Object Names

The names of databases, tables, other objects or performance groups specified in the CHECK command can consist of the following inclusive characters:

  • Lowercase alphabet (a … z)
  • Uppercase alphabet (A … Z)
  • Digits (0 … 9)
  • The following special characters.
  •  

    Special characters …

    Include …

    Parentheses, braces, and brackets

  • ( ) (parentheses)
  • { } (curly braces)
  • [ ] (square brackets)
  • < > (angle brackets)
  • Punctuation marks

  • ` (grave accent)
  • ! (exclamation point)
  • ; (semicolon)
  • : (colon)
  • ' (apostrophe)
  • ? (question mark)
  • . (period)
  • , (comma)
  • Other

  • | (vertical line)
  • ~ (tilde)
  • @ (at sign)
  • $ (dollar sign)
  • = (equals sign)
  • % (percent sign)
  • + (plus)
  • # (number sign)
  • ^ (circumflex accent or caret)
  • & (ampersand)
  • * (asterisk)
  • - (hyphen-minus)
  • _ (low line or underscore)
  • / (forward slash)
  • \ (backward slash)
  • You must specify any name containing one or more special characters or blank spaces within apostrophes or double quotation marks, except for the following:

  • ? (question mark)
  • % (percent sign)
  • $ (dollar sign)
  • _ (low line or underscore)
  • [ ] (square brackets)
  • # (number sign)
  • Note: A name cannot begin with a digit (09).

    For more information on creating names, see “Basic SQL Syntax and Lexicon” in SQL Fundamentals.

    Examples

    The following examples show valid database or table names:

  • Table1
  • MYTABLE10
  • $$MyAccount
  • #Your_Account_$100
  • %mydatabase?
  • %
  • ???
  • The following examples show irregular but acceptable names:

  • '123'
  • “First&Second table”
  • 'my db1'
  • The following examples show unacceptable and non-valid names:

  • 123
  • First&Second table
  • my db1