sys.sp_change_feed_create_table_group (Transact-SQL)

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

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_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.

Related content

• sys.sp_help_change_feed (Transact-SQL)
• sys.sp_help_change_feed_table (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)