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.
Request Text Length | Where Request Text is Saved |
---|---|
Up to 12500 characters | TVM |
Exceeds 12500 characters | DBC.TextTbl This view contains the complete text of the object definition. Users need not use this view if there is no overflow in TVM.
|
The request text for an object is 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.