sqlsql-serverazuresql-azure-federations

Azure - How to get a list of federated databases?


In SQL Management studio, when connected to an Azure db, you can expand the 'Federations' folder and get a list of all federated databases. I'm trying to figure out the backing query that would find that info, but I'm having very limited success.

Could anyone point me at a table which may have that info?


Solution

  • Figured it out thanks to this url.

    I wanted the sys.federations and sys.federation_distributions tables.