meta_TableColumns
Returns the columns for the current tables of the systems in the repository. Corresponds to the relationship TableHasColumns.
Column |
Data Type |
Values |
|
SystemName |
VARCHAR(256) |
|
|
DatabaseName |
VARCHAR(128) |
|
|
TableName |
VARCHAR(128) |
|
|
ColumnName |
VARCHAR(128) |
|
|
ColumnId |
SMALLINT |
|
|
ColumnLoid |
INTEGER |
|
|
ColumnType |
CHAR(2) |
|
|
ColumnTypeA |
VARCHAR(29) |
|
|
ColumnLength |
INTEGER |
|
|
CharType |
SMALLINT |
|
|
CharacterSet |
VARCHAR(8) |
|
|
DecimalTotalDigits |
SMALLINT |
|
|
DecimalFractDigits |
SMALLINT |
|
|
UppercaseFlag |
VARCHAR(3) |
|
|
Nullable |
VARCHAR(3) |
|
|
DefaultValue |
VARCHAR(1024) |
|
|
Compressible |
VARCHAR(3) |
|
|
CompressValue |
VARCHAR(8192) |
|
|
IDColType |
VARCHAR(164) |
|
|
ColumnTitle |
VARCHAR(256) |
|
|
CommentString |
VARCHAR(255) |
|