DROP TRACE EVENT SESSION statement

Drops a trace event session.

Syntax

DROP TRACE EVENT SESSION [ IF EXISTS ] session-name UNCONDITIONALLY
[ ON SERVER ]

Remarks

When UNCONDITIONALLY is specified, dropping an active session automatically stops the session before removing its definition. Otherwise, an error is returned.

Specify the ON SERVER clause to drop a trace event session that is recording trace events from all databases on the database server. If this clause is not specified, then the trace event session on the current database is deleted.

System privileges

You must have the MANAGE ANY TRACE SESSION system privilege.

Side effects

None

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

The following statement drops the trace event session named my_session:

DROP TRACE EVENT SESSION my_session;