Skip to main content

INFORMATION.SCHEMA.COLUMNHISTOGRAMS

persistent class INFORMATION.SCHEMA.COLUMNHISTOGRAMS extends %Library.Persistent [ Final ]

SQL Table Name: INFORMATION_SCHEMA.COLUMN_HISTOGRAMS

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

property BUCKETPOSITION as %Integer [ SqlFieldName = BUCKET_POSITION , Required ];
Property methods: BUCKETPOSITIONDisplayToLogical(), BUCKETPOSITIONGet(), BUCKETPOSITIONIsValid(), BUCKETPOSITIONLogicalToDisplay(), BUCKETPOSITIONNormalize(), BUCKETPOSITIONSet()
property BUCKETWIDTH as %Float [ SqlFieldName = BUCKET_WIDTH ];
Property methods: BUCKETWIDTHDisplayToLogical(), BUCKETWIDTHGet(), BUCKETWIDTHIsValid(), BUCKETWIDTHLogicalToDisplay(), BUCKETWIDTHNormalize(), BUCKETWIDTHSet()
property COLUMNNAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = COLUMN_NAME , Required ];
Name of the column.
Property methods: COLUMNNAMEDisplayToLogical(), COLUMNNAMEGet(), COLUMNNAMEIsValid(), COLUMNNAMELogicalToDisplay(), COLUMNNAMELogicalToOdbc(), COLUMNNAMENormalize(), COLUMNNAMESet()
property INTERPOLATABLE as %Boolean;
Property methods: INTERPOLATABLEDisplayToLogical(), INTERPOLATABLEGet(), INTERPOLATABLEIsValid(), INTERPOLATABLELogicalToDisplay(), INTERPOLATABLENormalize(), INTERPOLATABLESet()
property NULLBUCKETS as %Integer [ SqlFieldName = NULL_BUCKETS ];
Property methods: NULLBUCKETSDisplayToLogical(), NULLBUCKETSGet(), NULLBUCKETSIsValid(), NULLBUCKETSLogicalToDisplay(), NULLBUCKETSNormalize(), NULLBUCKETSSet()
property ORDINALPOSITION as %Integer [ SqlFieldName = ORDINAL_POSITION , Required ];
Column's ordinal position within the table.
Property methods: ORDINALPOSITIONDisplayToLogical(), ORDINALPOSITIONGet(), ORDINALPOSITIONIsValid(), ORDINALPOSITIONLogicalToDisplay(), ORDINALPOSITIONNormalize(), ORDINALPOSITIONSet()
property PERCENTILE as %Float;
Property methods: PERCENTILEDisplayToLogical(), PERCENTILEGet(), PERCENTILEIsValid(), PERCENTILELogicalToDisplay(), PERCENTILENormalize(), PERCENTILESet()
property TABLECATALOG as %String (MAXLEN = 128) [ Calculated , SqlFieldName = TABLE_CATALOG ];
Table qualifier - always NULL in InterSystems IRIS
Property methods: TABLECATALOGCompute(), TABLECATALOGDisplayToLogical(), TABLECATALOGGet(), TABLECATALOGIsValid(), TABLECATALOGLogicalToDisplay(), TABLECATALOGLogicalToOdbc(), TABLECATALOGNormalize(), TABLECATALOGSQLCompute()
property TABLENAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = TABLE_NAME , Required ];
Name of the table.
Property methods: TABLENAMEDisplayToLogical(), TABLENAMEGet(), TABLENAMEIsValid(), TABLENAMELogicalToDisplay(), TABLENAMELogicalToOdbc(), TABLENAMENormalize(), TABLENAMESet()
property TABLESCHEMA as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = TABLE_SCHEMA , Required ];
Name of schema that contains the table.
Property methods: TABLESCHEMADisplayToLogical(), TABLESCHEMAGet(), TABLESCHEMAIsValid(), TABLESCHEMALogicalToDisplay(), TABLESCHEMALogicalToOdbc(), TABLESCHEMANormalize(), TABLESCHEMASet()
property VALUE as %String;
Property methods: VALUEDisplayToLogical(), VALUEGet(), VALUEIsValid(), VALUELogicalToDisplay(), VALUELogicalToOdbc(), VALUENormalize(), VALUESet()

Inherited Members

Inherited Methods

Storage

Storage Model: SQLStorage

Maps: 1

  • Map number 1 is named Master

    thismap.Global: ^oddSQL

  • ^oddSQL({SchemaExact},{TableExact},8,{ORDINAL_POSITION},{BUCKET_POSITION})
    =
    Node Delimiter Piece Name
    VALUE
FeedbackOpens in a new tab