sys.sp_change_feed_drop_table_group (Transact-SQL)
Applies to: SQL Server 2022 (16.x) Azure SQL Database Azure Synapse Analytics Microsoft Fabric
Drops a table group and internal metadata objects for Azure Synapse Link for SQL or Microsoft Fabric mirrored databases (Preview).
Note
This system stored procedure is used internally and is not 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 is 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)
For Microsoft Fabric mirrored databases:
- Microsoft Fabric mirrored databases (Preview)
- Microsoft Fabric mirrored databases monitoring
- Explore data in your Mirrored database using Microsoft Fabric
For Azure Synapse Link:
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for