sys.federations (Azure SQL Database)

Returns the federations within a database.

Important note Important

The current implementation of Federations will be retired with Web and Business service tiers. Consider deploying custom sharding solutions to maximize scalability, flexibility, and performance. For more information about custom sharding, see Scaling Out Azure SQL Databases.

Applies to: Azure SQL Database.

Columns

Data type

Description

federation_id

int

Unique identifier for the federation within the root database.

name

sysname

Name of the federation.

federation_id is unique within a root database.

member_id is unique within a federation.

Community Additions

Show: