Edit

Share via

sys.sp_help_change_feed_table (Transact-SQL)

Applies to: SQL Server 2022 (16.x) and later versions Azure SQL Database Azure SQL Managed Instance 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:

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