Database Reference
In-Depth Information
Figure 8.37
Query federated table on second federation member.
9. Highlight the code and click the
Run
button on the ribbon. he query result is shown
in Figure 8.38 where only one row with ClassID 201205 is selected.
10. To view the structure of the federation member, you can query the metadata stored in
the built-in view sys.federation_member_distributions with the following SQL state-
ment in the
New Query
pane:
Figure 8.38
Query federated table with FILTERING
=
ON.
