extended-events-tables-trace-xe-action-map.md

title	trace_xe_action_map (Transact-SQL)
description	Extended Events Tables - trace_xe_action_map
author	VanMSFT
ms.author	vanto
ms.date	06/10/2016
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	trace_xe_action_map_TSQL trace_xe_action_map
helpviewer_keywords	extended events [SQL Server], tables trace_xe_action_map
dev_langs	TSQL

Extended Events Tables - trace_xe_action_map

[!INCLUDE 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.

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.

Remarks

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.

See Also

trace_xe_event_map (Transact-SQL)