sys.sp_help_change_feed_table (Transact-SQL)
Applies to: 
SQL Server 2022 (16.x)
Azure SQL Database
Azure Synapse Analytics
Microsoft Fabric
Provides the provision or deprovision status and information of table group and table metadata.
This system stored procedure is used for:
- The Azure Synapse Link feature for SQL Server instances and Azure SQL Database. For more information, see Manage Azure Synapse Link for SQL Server and Azure SQL Database.
- The Fabric Mirrored Database feature for Azure SQL Database. For more information, see What is Mirroring in Fabric?
Syntax
Transact-SQL syntax conventions
EXECUTE sys.sp_help_change_feed_table;
Arguments
@table_group_id
The unique identifier of the table group
@table_id
The source table identifier
@source_schema
The source table schema name
@source_name
The source table name
Result set
| Column name | Data type | Description |
|---|---|---|
table_group_id |
uniqueidentifier | The unique identifier of the table group. |
table_group_name |
nvarchar(140) | The name of the table group. |
schema_name |
sysname | The schema name of the original table |
table_name |
sysname | The name of the original table. |
table_id |
uniqueidentifier | The source table identifier. |
destination_location |
nvarchar(512) | URL string of the landing zone folder. |
workspace_id |
nvarchar(247) | The related Synapse workspace Azure resource ID. |
state |
nvarchar(50) | The current state of the table. |
table_object_id |
int | The object ID of the change feed table. |
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_settings (Transact-SQL)
- sys.sp_help_change_feed_table_groups (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:
- What is Mirroring in Fabric?
- Monitor Fabric mirrored database replication
- Explore data in your Mirrored database using Microsoft Fabric
For Azure Synapse Link: