17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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


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.