0

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?

Kyle
  • 17,317
  • 32
  • 140
  • 246

1 Answers1

0

Figured it out thanks to this url.

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

Kyle
  • 17,317
  • 32
  • 140
  • 246