Export (0) Print
Expand All

sys.federated_table_columns (Azure SQL Database)

Returns specialized federation properties of federated tables.

Important note Important

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.

Applies to: Azure SQL Database.

Column name

Data type

Description

object_id

int

Object ID for the table.

column_id

int

Column ID for the column in the table.

distribution_name

sysname

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

Community Additions

ADD
Show:
© 2014 Microsoft