Table of Contents

Class AzureSynapseAnalyticsSchema.DatabaseMapping

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.pdw_database_mappings (Transact-SQL)

Applies to: √ Analytics Platform System (PDW)

Maps the database_ids of databases to the physical name used on Compute nodes, and provides the principal id of the database owner on the system. Join sys.pdw_database_mappings to sys.databases and sys.pdw_nodes_pdw_physical_databases.


See sys.pdw_database_mappings.

[Table(Schema = "sys", Name = "pdw_database_mappings", IsView = true)]
public class AzureSynapseAnalyticsSchema.DatabaseMapping
Inheritance
AzureSynapseAnalyticsSchema.DatabaseMapping
Extension Methods

Properties

DatabaseID

The object ID for the database. See sys.databases (Transact-SQL).

physical_name and database_id form the key for this view.

[Column("database_id")]
[NotNull]
public int DatabaseID { get; set; }

Property Value

int

PhysicalName

The physical name for the database on the Compute nodes.

physical_name and database_id form the key for this view.

[Column("physical_name")]
[NotNull]
public string PhysicalName { get; set; }

Property Value

string