Export (0) Print
Expand All

sys.federation_distributions (Azure SQL Database)

Returns the distribution type and data types used by a federation.

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.

Columns

Data type

Description

federation_id

int

Unique identifier for the federation

distribution_name

sysname

Name identifier for the federation key

distribution_type

nvarchar(60)

RANGE

system_type_id

tinyint

The system data type id for federation data types.

max_length

smallint

Maximum length (in bytes) of the column.

-1 = Column data type is varchar(max), nvarchar(max), varbinary(max), or xml.

For text columns, the max_length value will be 16 or the value set by sp_tableoption ‘text in row’.

precision

tinyint

Precision of the column if numeric-based; otherwise, 0.

scale

tinyint

Scale of the column if numeric-based; otherwise, 0.

collation_name

sysname

Name of the collation of the column if character-based; otherwise, NULL.

user_type_id

int

ID of the type. For system data types, user_type_id = system_type_id.

boundary_value_in_high

bit

For range partitioning. Will always contain a value of 1.

Community Additions

Show:
© 2015 Microsoft