17.00 - Usage Notes - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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.