Applies To: SQL Server
Contains one row for each Extended Events action that is mapped to a SQL Trace column ID. This table is stored in the master database, in the sys schema.
|Applies to: SQL Server (SQL Server 2012 through current version).|
|Column name||Data type||Description|
|trace_column_id||smallint||The ID of the SQL Trace column that is being mapped.|
|package_name||nvarchar(60)||The name of the Extended Events package where the mapped action resides.|
|xe_action_name||nvarchar(60)||The name of the Extended Events action that is mapped to the SQL Trace column.|
You can use the following query to identify the Extended Events actions that are equivalent to the SQL Trace columns:
SELECT tc.name AS trace_column, am.package_name, am.xe_action_name FROM sys.trace_columns AS tc INNER JOIN sys.trace_xe_action_map AS am ON tc.trace_column_id = am.trace_column_id
SQL Trace columns that do not map to actions are not included in the table.