sys.sp_help_change_feed_table (Transact-SQL)
Applies to: 
SQL Server 2022 (16.x)
Azure SQL Database
Azure Synapse Analytics
Warehouse in Microsoft Fabric
SQL database in 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 Microsoft Fabric mirrored databases.
- SQL database in Microsoft Fabric. For more information, see SQL database in Microsoft 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.