Table of Contents

Class AzureSynapseAnalyticsSchema.NodesColumn

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

sys.pdw_nodes_columns (Transact-SQL)

Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Shows columns for user-defined tables and user-defined views.


See sys.pdw_nodes_columns.

[Table(Schema = "sys", Name = "pdw_nodes_columns", IsView = true)]
public class AzureSynapseAnalyticsSchema.NodesColumn
Inheritance
AzureSynapseAnalyticsSchema.NodesColumn
Inherited Members
Extension Methods

Properties

CollationName

collation_name NOT NULL sysname

Name of the collation of the column if character-based; otherwise, NULL. 
[Column("collation_name")]
[NotNull]
public string CollationName { get; set; }

Property Value

string

ColumnID

column_id NOT NULL int

ID of the column. Unique in object. 
[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }

Property Value

int

DefaultObjectID

default_object_id NOT NULL int

ID of the default object; 0 = No default.
Range: Always 0. 
[Column("default_object_id")]
[NotNull]
public int DefaultObjectID { get; set; }

Property Value

int

IsAnsiPadded

is_ansi_padded NOT NULL bit

1 = Column uses ANSI_PADDING ON behavior if character, binary, or variant.
Range: Always 0. 
[Column("is_ansi_padded")]
[NotNull]
public bool IsAnsiPadded { get; set; }

Property Value

bool

IsColumnSet

is_column_set NOT NULL bit

1 = Column is a column set.
Range: Always 0. 
[Column("is_column_set")]
[NotNull]
public bool IsColumnSet { get; set; }

Property Value

bool

IsComputed

is_computed NOT NULL bit

1 = Column is a computed column.
Range: Always 0. 
[Column("is_computed")]
[NotNull]
public bool IsComputed { get; set; }

Property Value

bool

IsDtsReplicated

is_dts_replicated NOT NULL bit

1 = Column is replicated by using SSIS.
Range: Always 0. 
[Column("is_dts_replicated")]
[NotNull]
public bool IsDtsReplicated { get; set; }

Property Value

bool

IsFilestream

is_filestream NOT NULL bit

1 = Column is a FILESTREAM column.
Range: Always 0. 
[Column("is_filestream")]
[NotNull]
public bool IsFilestream { get; set; }

Property Value

bool

IsIdentity

is_identity NOT NULL bit

1 = Column has identity values.
Range: Always 0. 
[Column("is_identity")]
[NotNull]
public bool IsIdentity { get; set; }

Property Value

bool

IsMergePublished

is_merge_published NOT NULL bit

1 = Column is merge-published.
Range: Always 0. 
[Column("is_merge_published")]
[NotNull]
public bool IsMergePublished { get; set; }

Property Value

bool

IsNonSqlSubscribed

is_non_sql_subscribed NOT NULL bit

1 = Column has a non-SQL subscriber.
Range: Always 0. 
[Column("is_non_sql_subscribed")]
[NotNull]
public bool IsNonSqlSubscribed { get; set; }

Property Value

bool

IsNullable

is_nullable NOT NULL bit

1 = Column is nullable. 
[Column("is_nullable")]
[NotNull]
public bool IsNullable { get; set; }

Property Value

bool

IsReplicated

is_replicated NOT NULL bit

1 = Column is replicated.
Range: Always 0. 
[Column("is_replicated")]
[NotNull]
public bool IsReplicated { get; set; }

Property Value

bool

IsRowGuidCol

is_rowguidcol NOT NULL bit

1 = Column is a declared ROWGUIDCOL.
Range: Always 0. 
[Column("is_rowguidcol")]
[NotNull]
public bool IsRowGuidCol { get; set; }

Property Value

bool

IsSparse

is_sparse NOT NULL bit

1 = Column is a sparse column.
Range: Always 0. 
[Column("is_sparse")]
[NotNull]
public bool IsSparse { get; set; }

Property Value

bool

IsXmlDocument

is_xml_document NOT NULL bit

1 = Content is a complete XML document.
Range: Always 0. 
[Column("is_xml_document")]
[NotNull]
public bool IsXmlDocument { get; set; }

Property Value

bool

MaxLength

max_length NOT NULL smallint

Maximum length (in bytes) of the column.
Range: Includes -1 (not valid) for unsupported column types. 
[Column("max_length")]
[NotNull]
public short MaxLength { get; set; }

Property Value

short

Name

name NOT NULL sysname

Name of the column. Unique in object. 
[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

object_id NOT NULL int

ID of the object to which this column belongs. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

PdwNodeID

pdw_node_id NOT NULL int

Unique identifier of a Azure Synapse Analytics node.
Range: NOT NULL 
[Column("pdw_node_id")]
[NotNull]
public int PdwNodeID { get; set; }

Property Value

int

Precision

precision NOT NULL tinyint

Precision of the column if numeric-based; otherwise, 0. 
[Column("precision")]
[NotNull]
public byte Precision { get; set; }

Property Value

byte

RuleObjectID

rule_object_id NOT NULL int

ID of the stand-alone rule bound to the column.
0 = No stand-alone rule.
Range: Always 0. 
[Column("rule_object_id")]
[NotNull]
public int RuleObjectID { get; set; }

Property Value

int

Scale

scale NOT NULL tinyint

Scale of column if numeric-based; otherwise, 0. 
[Column("scale")]
[NotNull]
public byte Scale { get; set; }

Property Value

byte

SystemTypeID

system_type_id NOT NULL tinyint

ID of the system type of the column. 
[Column("system_type_id")]
[NotNull]
public byte SystemTypeID { get; set; }

Property Value

byte

UserTypeID

user_type_id NOT NULL int

ID of the type of the column as defined by the user. 
[Column("user_type_id")]
[NotNull]
public int UserTypeID { get; set; }

Property Value

int

XmlCollectionID

xml_collection_id NOT NULL int

0 = No XML schema collection.
Range: Always 0. 
[Column("xml_collection_id")]
[NotNull]
public int XmlCollectionID { get; set; }

Property Value

int