Compatibility Views | Data Dictionary | Teradata Vantage - 17.10 - Compatibility 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)

Compatibility views convert the native variable length Unicode object names into 30 bytes of either Latin or Kanji1.This can cause loss of information by truncation or inability to convert object names longer than 30 characters into Latin or Kanji1. Characters that cannot be converted are replaced by the substitution character, which is 0x1A for both Latin and Kanji1.

As with all character data, when object names are returned to the user they are converted to the session character set. This conversion can produce loss of information if the characters in the object name cannot be converted to the session character set or exceed the export width for the character data.

Compatibility view names use the format:
  • view_name
  • view_nameX
Some non compatibility views also use this format and are not deprecated, such as BusinessCalendar.

For example, All_RI_Children or All_RI_ChildrenX, where the X denotes a partial view that omits restricted data, such as security-related information.

A Unicode view exists for every compatibility view in database DBC. The information available in compatibility views is available from the corresponding Unicode view, and compatibility views should no longer be used to obtain the required information.

Teradata strongly encourages you to switch over to Unicode views. The following compatibility views and compatibility X views are deprecated.

In the following list, views ending in “[X]” indicate there is both a compatibility view and a compatibility X view; for example, DBC.AccountInfo and DBC.AccountInfoX are shown as DBC.AccountInfo[X].

  • DBC.AccessLog
  • DBC.AccLogRules
  • DBC.AccountInfo[X]
  • DBC.AllRights[X]
  • DBC.AllRoleRights
  • DBC.AllSpace[X]
  • DBC.AllTempTables[X]
  • DBC.All_RI_Children[X]
  • DBC.All_RI_Parents[X]
  • DBC.AMPUsage[X]
  • DBC.Association[X]
  • DBC.Authorizations[X]
  • DBC.CharSets
  • DBC.CharTranslations
  • DBC.Children[X]
  • DBC.Collations
  • DBC.Columns[X]
  • DBC.ConnectRules
  • DBC.CSPSESSIONINFO
  • DBC.Databases[X]
  • DBC.Databases2[X]
  • DBC.Database_Default_Journals[X]
  • DBC.DBCInfo
  • DBC.DBQLRules
  • DBC.DeleteAccessLog
  • DBC.DeleteOldInDoubt
  • DBC.DiskSpace[X]
  • DBC.Events[X]
  • DBC.Events_Configuration[X]
  • DBC.Events_Media[X]
  • DBC.ExternalSPs[X]
  • DBC.Functions[X]
  • DBC.HostsInfo
  • DBC.IndexConstraints[X]
  • DBC.Indices[X]
  • DBC.InDoubtLog
  • DBC.Journals[X]
  • DBC.LogOnOff[X]
  • DBC.LogonRules
  • DBC.ownerdb
  • DBC.ProfileInfo[X]
  • DBC.QryLog[X]
  • DBC.QryLogEventHis
  • DBC.QryLogEvents
  • DBC.QryLogExceptions
  • DBC.QryLogExplain
  • DBC.QryLogObjects
  • DBC.QryLogParam
  • DBC.QryLogSQL
  • DBC.QryLogSteps
  • DBC.QryLogSummary
  • DBC.QryLogTDWM
  • DBC.QryLogTDWMSum
  • DBC.RCC_Configuration[X]
  • DBC.RCC_Media[X]
  • DBC.RepTables[X]
  • DBC.ResolvedDTS[X]
  • DBC.RestrictedWords
  • DBC.RI_Child_Tables[X]
  • DBC.RI_Distinct_Children[X]
  • DBC.RI_Distinct_Parents[X]
  • DBC.RI_Parent_Tables[X]
  • DBC.RoleInfo[X]
  • DBC.RoleMembers[X]
  • DBC.SecurityDefaults
  • DBC.SecurityLog[X]
  • DBC.SessionInfo[X]
  • DBC.SHOWCOLCHECKS[X]
  • DBC.SHOWTBLCHECKS[X]
  • DBC.Software_Event_Log
  • DBC.Table_LevelConstraints[X]
  • DBC.Tables[X]
  • DBC.Tables2[X]
  • DBC.TableSize[X]
  • DBC.TableText[X]
  • DBC.Triggers[X]
  • DBC.UserGrantedRights
  • DBC.UserRights
  • DBC.UserRoleRights
  • DBC.Users
  • DBC.User_Default_Journals[X]