Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the schema information for all the objects.
Note
Event objects expose fixed schemas for both read-only and read-write data.
Column name |
Data type |
Description |
|---|---|---|
name |
nvarchar(60) |
The name of the column. name is unique within the object. Is not nullable. |
column_id |
int |
The identifier of the column. column_id is unique within the object when used with column_type. Is not nullable. |
object_name |
nvarchar(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_guid |
uniqueidentifier |
The GUID of the package that contains the object. Is not nullable. |
type_name |
nvarchar(60) |
The name of the type for this column. Is not nullable. |
type_package_guid |
uniqueidentifier |
The GUID of the package that contains the column data type. Is not nullable. |
column_type |
nvarchar(60) |
Indicates how this column is used. column_type can be one of the following:
Note Changing this value can modify the behavior of the object. Is not nullable. |
column_value |
nvarchar(256) |
Displays static values associated with the object column. Is nullable. |
capabilities |
int |
A bitmap describing the capabilities of the column. Is nullable. |
capabilities_desc |
nvarchar(256) |
A description of this object column's capabilities. This value can be one of the following:
|
description |
nvarchar(256) |
The description of this object column. Is nullable. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Relationship Cardinalities
From |
To |
Relationship |
|---|---|---|
sys.dm_xe_object_columns.object_name, sys.dm_xe_object_columns.object_package_guid |
sys.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 |
Updated content |
|---|
Corrected the description for the description column to indicate that the value is nullable. |