Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.federated_table_columns (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 Federation Views.

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 specialized federation properties of federated tables. Sys.federated_table_columns is specific to Microsoft Azure SQL Database and is not supported in on-premises SQL Server.


Column name Data type Description



Object_id for the table



Column_id for the column in the table



Distribution_name mapping for the federated table column

All general table metadata for federated tables is stored the same as non-federated table metadata in well-known system metadata tables such as sys.objects

© 2015 Microsoft