VERKOOP: 1-800-867-1389
EN
Deze inhoud is niet beschikbaar in uw taal, maar wel in het Engels.

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

Vindt u dit nuttig?
(1500 tekens resterend)
Bedankt voor uw feedback
Weergeven:
© 2014 Microsoft