drop-event-session-transact-sql.md

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

[!INCLUDEsql-server-tsql-previous-offline-documentation]

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)