Azure - How to get a list of federated databases?

70 Views Asked by At

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?

1

There are 1 best solutions below

0
On BEST ANSWER

Figured it out thanks to this url.

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