Edit

sys.sp_change_feed_create_table_group (Transact-SQL)

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

sys.sp_change_feed_create_table_group
    [ @table_group_id = ] 'table_group_id'
    , [ @table_group_name = ] N'table_group_name'
    [ , [ @workspace_id = ] N'workspace_id' ]
    [ , [ @destination_location = ] N'destination_location' ]
    [ , [ @destination_credential = ] N'destination_credential' ]
[ ; ]

Arguments

[ @table_group_id = ] 'table_group_id'

The unique identifier of the table group.

[ @table_group_name = ] N'table_group_name'

The name of the table group.

[ @workspace_id = ] N'workspace_id'

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

[ @destination_location = ] N'destination_location'

URL string of the landing zone folder.

[ @destination_credential = ] N'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

  • Last updated on