Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Columns Element

Columns Element (ASSL)


Applies To: SQL Server 2016 Preview

Contains the collection of columns associated with the parent element.

<Action xsi:type="DrillThroughAction"> <!-- or one of the elements listed below in the Element Relationships table -->
      <Column xsi:type="MeasureBinding">...</Column> <!-- parent: DrillThroughAction -->
      <!-- or -->
      <Column xsi:type="CubeAttributeBinding">...</Column> <!-- parent: DrillThroughAction -->
      <!-- or -->
      <Column xsi:type="EventColumn">...</Column> <!-- parent: Event -->
      <!-- or -->
      <Column xsi:type="MiningModelColumn">...</Column> <!-- parent: MiningModel or MiningModelColumn -->
      <!-- or -->
      <Column xsi:type="MiningStructureColumn">...</Column> <!-- parent: MiningStructure or TableMiningStructureColumn -->



Data type and length


Default value



Ancestor or Parent



1-1: Required element that occurs once and only once.

All others

0-1: Optional element that can occur once and only once.

For DrillThroughAction elements, the Columns collection identifies the columns that contain data to be returned when the action is performed.

For TableMiningStructureColumn elements, the Columns collection allows only one level of recursion. In other words, any TableMiningStructureColumn element included in this collection cannot contain any TableMiningStructureColumn elements in its Columns collection.

Some of the corresponding elements in the Analysis Management Objects (AMO) object model are TraceColumnCollection, MiningModelColumnCollection, and MiningStructureColumnCollection.

Community Additions

© 2015 Microsoft