Describes all the columns for each monitoring table. No configuration options are required for monTableColumns.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
TableID |
int |
Unique identifier for the view |
|
ColumnID |
int |
Position of the column |
|
TypeID |
int |
Identifier for the datatype of the column |
|
Precision |
tinyint |
Precision of the column, if numeric |
|
Scale |
tinyint |
Scale of the column, if numeric |
|
Length |
smallint |
Maximum length of the column (in bytes) |
|
Indicators |
int |
Indicators for specific column properties (for example, if the column is prone to wrapping and should be sampled) |
|
TableName |
varchar(30) |
null |
Name of the table |
ColumnName |
varchar(30) |
null |
Name of the column |
TypeName |
varchar(21) |
null |
Name of the datatype of the column |
Description |
varchar(255) |
null |
Description of the column |
