TWM supports standard ASCII character object names, as well as Teradata special characters (such as White Space, Asterisk, and so on) and 8-bit characters. All SQL generated by TWM contains double quotes around Teradata object names. Multi-byte object names are also supported.
Beginning with Teradata 14.10, a system option is available in the DBS Control Record to allow object names to have up to 128 Unicode characters rather than the usual 30 characters of the default character set. When this Teradata release and option is in use, TWM supports these Extended Object Names for input databases, tables, columns, and indexes. Output databases, tables, columns, and procedures are still limited to 30 characters.
One limitation of Extended Object Name support is, when publishing, an Input Database, Input Table, Anchor Database, or Anchor Table with an Extended Object Name is truncated to 30 characters. You must restore these names manually to their full value in the Model Manager using the Edit feature.
Object names with trailing spaces are not supported in TWM. This is in part because some database help information is returned with object names padded with spaces which must be removed, making it difficult to find a match if the real object names have one or more trailing spaces.
Temporary or work tables and views created by TWM usually begin with _twm, so it is recommended to not begin object names with these characters.