drop-event-session-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
DROP EVENT SESSION (Transact-SQL)	DROP EVENT SESSION (Transact-SQL)	markingmyname	maghan	03/06/2017	sql	t-sql	reference	DROP_EVENT_SESSION_TSQL DROP EVENT SESSION	event sessions [SQL Server] DROP EVENT SESSION statement	TSQL

DROP EVENT SESSION (Transact-SQL)

[!INCLUDE SQL Server]

Drops an event session.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

DROP EVENT SESSION event_session_name  
ON SERVER  

Arguments

event_session_name
Is the name of an existing event session.

Remarks

When you drop an event session, all configuration information, such as targets and session parameters, is completely removed.

Permissions

Requires the ALTER ANY EVENT SESSION permission.

Examples

The following example shows how to drop an event session.

DROP EVENT SESSION evt_spin_lock_diagnosis ON SERVER;
GO

See Also

CREATE EVENT SESSION (Transact-SQL)
ALTER EVENT SESSION (Transact-SQL)
sys.server_event_sessions (Transact-SQL)