sys.dm_xe_object_columns (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the schema information for all the objects.

System_CAPS_ICON_note.jpg Note


Event objects expose fixed schemas for both read-only and read-write data.

Column nameData typeDescription
namenvarchar(60)The name of the column. name is unique within the object. Is not nullable.
column_idintThe identifier of the column. column_id is unique within the object when used with column_type. Is not nullable.
object_namenvarchar(60)The name of the object to which this column belongs. There is a many-to-one relationship with sys.dm_xe_objects.id. Is not nullable.
object_package_guiduniqueidentifierThe GUID of the package that contains the object. Is not nullable.
type_namenvarchar(60)The name of the type for this column. Is not nullable.
type_package_guiduniqueidentifierThe GUID of the package that contains the column data type. Is not nullable.
column_typenvarchar(60)Indicates how this column is used. Is not nullable. column_type can be one of the following:

readonly. The column contains a static value that cannot be changed.

data. The column contains run-time data exposed by the object.

customizable. The column contains a value that can be changed.

Note: Changing this value can modify the behavior of the object.
column_valuenvarchar(256)Displays static values associated with the object column. Is nullable.
capabilitiesintA bitmap describing the capabilities of the column. Is nullable.
capabilities_descnvarchar(256)A description of this object column's capabilities. This value can be one of the following:

Mandatory. The value must be set when binding the parent object to an event session.

NULL
descriptionnvarchar(256)The description of this object column. Is nullable.

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

FromToRelationship
sys.dm_xe_object_columns.object_name, sys.dm_xe_object_columns.object_package_guidsys.dm_xe_objects.name,

sys.dm_xe_objects.package_guid
Many-to-one
sys.dm_xe_object_columns.type_name

sys.dm_xe_object_columns.type_package_guid
sys.dm_xe_objects.name

sys.dm_xe_objects.package_guid
Many-to-one

Dynamic Management Views and Functions (Transact-SQL)

Community Additions

ADD
Show: