monTableColumns

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