sys-sp-drop-event-stream-group-transact-sql.md

title	sys.sp_drop_event_stream_group (Transact-SQL)
description	sys.sp_drop_event_stream_group drops an event stream group for the change event streaming feature.
author	nzagorac-ms
ms.author	nzagorac
ms.reviewer	mathoma, mikeray, randolphwest
ms.date	12/17/2025
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
ms.custom	ignite-2025
f1_keywords	sys_sp_drop_event_stream_group_TSQL sys_sp_drop_event_stream_group
helpviewer_keywords	sys_sp_drop_event_stream_group
dev_langs	TSQL
monikerRange	=sql-server-ver17 || =sql-server-linux-ver17

sys.sp_drop_event_stream_group (Transact-SQL)

[!INCLUDE sqlserver2025]

Drops a stream event group for the change event streaming (CES) feature introduced in [!INCLUDE sssql25-md] and Azure SQL Database.

[!INCLUDE change-event-streaming-preview]

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

Syntax

sys.sp_drop_event_stream_group [ @stream_group_name = ] N'stream_group_name'
[ ; ]

Arguments

[ @stream_group_name = ] N'stream_group_name'

Specifies the name of the event stream group you want to drop. @stream_group_name is sysname, with no default, and can't be NULL.

Permissions

A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.

Related content

• What is change event streaming (preview)?
• Configure change event streaming (preview)