SATıŞ: 1-800-867-1389
EN
Bu içerik dilinizde bulunmamaktadır ancak İngilizce sürümüne buradan bakabilirsiniz.

sys.federation_distributions (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 sys.federation_distributions.

ImportantImportant
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 the distribution type and data types used by a federation. sys.federation_distributions is specific to Microsoft Azure SQL Database and is not supported in on-premises SQL Server.

 

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.

Bunu faydalı buldunuz mu?
(1500 karakter kaldı)
Geri bildiriminiz için teşekkür ederiz
Show:
© 2014 Microsoft