16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

For information about the possible values for the TableKind column, see "TableKind Column."

Corresponding Tables

The X view references these additional tables:
  • DBC.AccessRights
  • DBC.DBase
  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles
  • DBC.TextTbl
  • DBC.TVM

RequestText

The request text data reflects the definitions specified by the user for the object.

IF the request text … THEN the request text is saved in …
is up to 12500 characters TVM
exceeds 12500 characters DBC.TextTbl

This view contains the complete text of the object definition.

Users do not need to use this view if there is no overflow in TVM.

The request text for an object could be stored in one or more rows depending on the size of the text. The LineNo column provides the sequence of multiple rows stored in the TextTbl for the object.

To put the text in a proper sequence, you must select the text using ORDER BY clause on LineNo from this view.