Exporteren (0) Afdrukken
Alles uitvouwen
Deze inhoud is niet beschikbaar in uw taal, maar wel in het Engels.

sys.federations (Azure SQL Database)

Updated: November 21, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference. See sys.federations.

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.

Returns the federations within a database. Sys.federations is specific to Microsoft Azure SQL Database and is not supported in on-premises SQL Server.


Columns Data type Description



Unique identifier for the federation within the root database.



Name of the federation.

Federation_id is unique within a root database.

Member_id is unique within a federation.

© 2015 Microsoft