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.