This topic has not yet been rated - Rate this topic

sys.federation_distributions (Windows Azure SQL Database)

Returns the distribution type and data types used by a federation. Sys.federation_distributions is specific to Windows Azure SQL Database and is not supported in on-premise 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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD