INFO.COLUMNSTORAGES DAX Function (Information)
Returns a list of all column storages in the current model with columns matching the schema rowset for column storage objects.
Syntax
Parameter | Attributes | Description |
---|---|---|
RestrictionName | Optional Repeatable |
Restriction name. |
RestrictionValue | Optional Repeatable |
Restriction value. |
Return values
Field | Type |
---|---|
ID | Integer |
ColumnID | Integer |
Name | String |
StoragePosition | Integer |
DictionaryStorageID | Integer |
Settings | Integer |
ColumnFlags | Integer |
Collation | String |
OrderByColumn | String |
Locale | Integer |
BinaryCharacters | Integer |
Statistics_DistinctStates | Integer |
Statistics_MinDataID | Integer |
Statistics_MaxDataID | Integer |
Statistics_OriginalMinSegmentDataID | Integer |
Statistics_RLESortOrder | Integer |
Statistics_RowCount | Integer |
Statistics_HasNulls | Boolean |
Statistics_RLERuns | Integer |
Statistics_OthersRLERuns | Integer |
Statistics_Usage | Integer |
Statistics_DBType | Integer |
Statistics_XMType | Integer |
Statistics_CompressionType | Integer |
Statistics_CompressionParam | Integer |
Statistics_EncodingHint | Integer |
IsDeltaPartitionColumn | Boolean |
DeltaColumnMappingPhysicalName | String |
DeltaColumnMappingId | Integer |
FramedSourceColumn | String |
Remarks
Corresponds to the TMSCHEMA_COLUMN_STORAGES data management view (DMV).
As all the INFO functions, it cannot be used in calculated tables and calculated columns.
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation not available.
The function may be undocumented or unsupported. Check the Compatibility box on this page.