| title | sys.sp_remove_object_from_event_stream_group (Transact-SQL) | ||
|---|---|---|---|
| description | Removes a table from a stream group for the change event streaming feature introduced in [!INCLUDE [sssql25-md](../../includes/sssql25-md.md)] by using Transact-SQL (T-SQL). | ||
| author | nzagorac-ms | ||
| ms.author | nzagorac | ||
| ms.reviewer | mathoma, mikeray, randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| ms.custom |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
||
| monikerRange | =sql-server-ver17 || =sql-server-linux-ver17 |
[!INCLUDE sqlserver2025]
Removes an object (that is, a table) from the stream 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
sys.sp_remove_object_from_event_stream_group
[ @stream_group_name = ] N'stream_group_name'
, [ @object_name ] = N'schema_name_dot_object_name'
Specifies the name of the event stream group from which you want to remove the table. @stream_group_name is sysname, and can't be NULL.
Specifies the name of the table you want to remove from the specified stream group. @object_name is nvarchar(512), and can't be NULL.
0 (success) or 1 (failure).
A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.