sys.sp_change_feed_drop_table_group (Transact-SQL)

Applies to: SQL Server 2022 (16.x) and later versions Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Preview

Drops a table group and internal metadata objects.

This system stored procedure is used for:

• SQL database in Microsoft Fabric
• Microsoft Fabric mirrored databases
• Azure Synapse Link

Syntax

Transact-SQL syntax conventions

sys.sp_change_feed_drop_table_group
    @table_group_id
[ ; ]

Arguments

@table_group_id

Required. Data type is uniqueidentifier. The unique identifier of the table group. It's a GUID generated by the initial setup.

Permissions

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

Related content

• sys.sp_help_change_feed (Transact-SQL)
• sys.sp_help_change_feed_table (Transact-SQL)
• sys.sp_change_feed_configure_parameters (Transact-SQL)
• sys.dm_change_feed_log_scan_sessions (Transact-SQL)
• sys.dm_change_feed_errors (Transact-SQL)