sys.sp_change_feed_create_table_group (Transact-SQL)

2025-05-19

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

Creates a source to maintain metadata specific to each table group. A table group represents the container for all the individual tables that will be replicated.

Caution

This system stored procedure is used internally and isn't recommended for direct administrative use. Use Synapse Studio or the Fabric portal instead. Using this procedure could introduce inconsistency.

This system stored procedure is used for:

Syntax

Transact-SQL syntax conventions

EXECUTE sys.sp_change_feed_create_table_group
    @table_group_id
    , @table_group_name
    , @workspace_id
    , @destination_location
    , @destination_credential
[ ; ]

Arguments

@table_group_id

The unique identifier of the table group.

@table_group_name

The name of the table group.

@workspace_id

Azure resourceID for the workspace requesting creation of the new table group.

@destination_location

URL string of the landing zone folder.

@destination_credential

The credential name to access the landing zone.

Permissions

A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.

Share via