Unicode Views | Data Dictionary | Teradata Vantage - 17.10 - Unicode Views - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

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

Because data dictionary tables can change, views provide greater stability.

In Unicode views, object names are returned in the session character set. The substitution character for the session character set is returned for any characters in the object name that do not exist in the session character set.

Unicode view names use the following formats:
  • view_name V
  • view_name VX

For example, All_RI_ChildrenV or All_RI_ChildrenVX, where the “X” denotes a partial view that omits certain restricted data, such as security-related information.