15.10 - TableTextV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Schema

DBC

 

View Column

Data Type

Format

Source Table.Column

DataBaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

TableName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

TableKind

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

TVM.TableKind

RequestText

VARCHAR(32000)

UNICODE

X(255)

TextTbl.TextString

LineNo

SMALLINT

NOT NULL

---,--9 (explicit)

TextTbl.LineNo

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.DBase
  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles
  • DBC.TextTbl
  • DBC.TVM
  • For information about the possible values for the TableKind column, see Appendix A: “View Column Values.”

    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.

    Note: 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.

    The following SELECT statement displays information about tables, views, and macros in the Personnel database, assuming that text for the database object is more than 12500 characters.

    SELECT TableName,TableKind, LineNo, RequestText( char(50)) FROM
    DBC.TableTextV WHERE DatabaseName = 'Personnel'  ORDER BY TableName, LineNo;