meta_TVColumns
Returns the columns for the tables and views defined in systems being tracked by MDS. The TVType fields returns 'T' for a table and 'V ' for a view.
|
Column |
Data Type |
|
SystemName |
VARCHAR(256) |
|
DatabaseName |
VARCHAR(128) |
|
TVType |
VARCHAR(2) |
|
TableName |
VARCHAR(128) |
|
ColumnName |
VARCHAR(128) |
|
ColumnID |
SMALLINT |
|
ColumnLoid |
INTEGER |
|
ColumnType |
CHAR(2) |
|
ColumnLength |
INTEGER |
|
CharType |
SMALLINT |
|
DecimalTotalDigits |
SMALLINT |
|
DecimalFractionalDigits |
SMALLINT |
|
UppercaseFlag |
VARCHAR(3) |
|
Nullable |
VARCHAR(3) |
|
DefaultValue |
VARCHAR(1024) |
|
Compressible |
VARCHAR(3) |
|
CompressValue |
VARCHAR(8192) |
|
IDColType |
VARCHAR(164) |
|
SPParameterType |
VARCHAR(1) |
|
ColumnTitle |
VARCHAR(256) |
|
CommentString |
VARCHAR(255) |
|
ColumnUDTName |
VARCHAR(128) |