Dışarıya aktar (0) Yazdır
Tümünü Genişlet
EN
Bu içerik dilinizde bulunmamaktadır ancak İngilizce sürümüne buradan bakabilirsiniz.

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.

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 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

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

Show:
© 2014 Microsoft