INFO.COLUMNSTORAGES DAX Function (Information)

Syntax  |  Return values  |  Remarks  

Returns a list of all column storages in the current model with columns matching the schema rowset for column storage objects.

Syntax

INFO.COLUMNSTORAGES ( [<RestrictionName> [, [<RestrictionValue>] [, <RestrictionName> [, [<RestrictionValue>] [, … ] ] ] ] ] )

Parameter	Attributes	Description
RestrictionName	Optional Repeatable	Restriction name.
RestrictionValue	Optional Repeatable	Restriction value.

Return values

Table An entire table or a table with one or more columns.

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: Nov 14, 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.