| title | sys.sp_change_feed_disable_table (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | The internal sys.sp_change_feed_disable_table system stored procedure disables a table in the change feed. | ||||
| author | WilliamDAssafMSFT | ||||
| ms.author | wiassaf | ||||
| ms.reviewer | randolphwest, ajayj, imotiwala | ||||
| ms.date | 12/17/2025 | ||||
| ms.service | fabric | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| ms.custom |
|
||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | >=sql-server-ver16 || =azuresqldb-current || =azuresqldb-mi-current || =fabric || =fabric-sqldb || =azure-sqldw-latest |
[!INCLUDE sqlserver2022-asdb-asdbmi-asa-fabricmirroredsqldb-fabricsqldb]
Removes a table from the change feed.
[!INCLUDE fabric-internal-use]
This system stored procedure is used for:
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sys.sp_change_feed_disable_table
@table_group_id
, @table_id
GO
Required. Data type is uniqueidentifier.
The unique identifier of the change feed table group that the table belongs to. It's a GUID generated by the initial setup.
Required. Data type is uniqueidentifier.
The unique identifier of the link table. It's the GUID generated by the setup flow and passed to the source publisher during provision.
The last changes published and synchronized to Azure Synapse can't be guaranteed. To guarantee synchronization between source and target up to a certain time, verify the "last transaction commit time" on the target and then call this procedure.
A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.