monTableColumns

Description

Describes all the columns for each monitoring table. monTableColumns helps determine what columns are in the monitoring tables. You can join monTableColumns with monTables to report columns and column attributes for the monitoring tables.

The metadata view for this table is identical for all instances in a shared-disk cluster.

You need not enable any configuration parameters for this monitoring table to collect data.

Columns

The columns for monTableColumns are:

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(20)	Null	Name of the datatype of the column.
Description	varchar(255)	Null	Description of the column (includes the column’s unit of measurement).
Language	varchar(30)		Allows you to specify the language in which Adaptive Server returns the values of the Description column and the Label column. By default, Adaptive Server returns US English. Queries must use the the IS0-639 and ISO-3166 naming conventions.
Label	varchar(50)		Description of the data presented in the column. You can use these values in application user interfaces instead of the actual column names.

The Indicators column is a bitmap. Use a bit mask to to determine which bits are turned on. Possible values are:

1 – the value for Indicators may increase rapidly and lead to counter wrapping if values reach 2³², which can occur in columns that have the number 1 bit in the Indicators column value turned on. To determine whether the 1 bit is turned on, use:
```
select TableName, ColumnName
from Master..monTableColumns
where Indicators & 1 != 0
```
2 – the counter is shared with sp_sysmon and is reset if you execute sp_sysmon. . .clear.

To display all columns sp_sysmon clears with the clear parameter, use:
```
Select TableName, ColumnName 
from master..monTableColumns 
where Indicators & 2 != 0
```