sys.sp_change_feed_drop_table_group (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Database Azure Synapse Analytics Warehouse in Microsoft Fabric SQL database in Microsoft Fabric

Drops a table group and internal metadata objects for Azure Synapse Link for SQL, Microsoft Fabric mirrored databases, and SQL database in Microsoft Fabric.

Note

This system stored procedure is used internally and isn't recommended for direct administrative use. Use Synapse Studio or the Fabric portal instead. Using this procedure could introduce inconsistency.

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)