Valid Characters in Object Names - Advanced SQL Engine - Teradata Database

The names of databases, tables, other objects or workload names 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)

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