sys.federations (Azure SQL Database)
Returns the federations within a database.
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. |
Remarks
federation_id is unique within a root database.
member_id is unique within a federation.