Skip to main content

INFORMATION.SCHEMA.COLUMNHISTOGRAMS

Class INFORMATION.SCHEMA.COLUMNHISTOGRAMS Extends %Persistent [ ClassType = persistent, Final, Owner = {_PUBLIC}, SqlRowIdPrivate, SqlTableName = COLUMN_HISTOGRAMS, StorageStrategy = SQLStorage, System = 4 ]

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

SchemaExact​

Property SchemaExact As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 45 ];

TableExact​

Property TableExact As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 46 ];

TABLECATALOG​

Property TABLECATALOG As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 2, SqlComputeCode = { set {*}="" }, SqlComputed, SqlFieldName = TABLE_CATALOG ];

Table qualifier - always NULL in InterSystems IRIS

TABLESCHEMA​

Property TABLESCHEMA As %String(COLLATION = "Upper", MAXLEN = 128) [ Required, SqlColumnNumber = 3, SqlFieldName = TABLE_SCHEMA ];

Name of schema that contains the table.

TABLENAME​

Property TABLENAME As %String(COLLATION = "Upper", MAXLEN = 128) [ Required, SqlColumnNumber = 4, SqlFieldName = TABLE_NAME ];

Name of the table.

COLUMNNAME​

Property COLUMNNAME As %String(COLLATION = "Upper", MAXLEN = 128) [ Required, SqlColumnNumber = 5, SqlFieldName = COLUMN_NAME ];

Name of the column.

ORDINALPOSITION​

Property ORDINALPOSITION As %Integer [ Required, SqlColumnNumber = 6, SqlFieldName = ORDINAL_POSITION ];

Column's ordinal position within the table.

BUCKETPOSITION​

Property BUCKETPOSITION As %Integer [ Required, SqlColumnNumber = 7, SqlFieldName = BUCKET_POSITION ];

BUCKETWIDTH​

Property BUCKETWIDTH As %Float [ SqlColumnNumber = 8, SqlFieldName = BUCKET_WIDTH ];

INTERPOLATABLE​

Property INTERPOLATABLE As %Boolean [ SqlColumnNumber = 9 ];

NULLBUCKETS​

Property NULLBUCKETS As %Integer [ SqlColumnNumber = 10, SqlFieldName = NULL_BUCKETS ];

PERCENTILE​

Property PERCENTILE As %Float [ SqlColumnNumber = 11 ];

VALUE​

Property VALUE As %String [ SqlColumnNumber = 12 ];