Class AzureSynapseAnalyticsSchema.NodesPhysicalDatabase

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.pdw_nodes_pdw_physical_databases (Transact-SQL)

Applies to: √ Analytics Platform System (PDW)

Contains a row for each physical database on a compute node. Aggregate physical database information to get detailed information about databases. To combine information, join the sys.pdw_nodes_pdw_physical_databases to the sys.pdw_database_mappings and sys.databases tables.

See sys.pdw_nodes_pdw_physical_databases.

[Table(Schema = "sys", Name = "pdw_nodes_pdw_physical_databases", IsView = true)]
public class AzureSynapseAnalyticsSchema.NodesPhysicalDatabase

Inheritance

object

AzureSynapseAnalyticsSchema.NodesPhysicalDatabase

Extension Methods

Map.DeepCopy<T>(T)

Properties

DatabaseID

The object ID for the database. Note that this value is not same as a database_id in the sys.databases (Transact-SQL) view.

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

Property Value

int

PdwNodeID

Unique numeric id associated with the node.

[Column("pdw_node_id")]
[NotNull]
public int PdwNodeID { get; set; }

Property Value

int

PhysicalName

The physical name for the database on the Shell/Compute nodes. This value is same as a value in the physical_name column in the sys.pdw_database_mappings (Transact-SQL) view.

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

Property Value

string