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

object

AzureSynapseAnalyticsSchema.NodesColumn

Extension Methods

Map.DeepCopy<T>(T)

Properties

CollationName

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

ID of the column. Unique in object.

[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }

Property Value

int

DefaultObjectID

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

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

1 = Column is a column set.
Range: Always 0.

[Column("is_column_set")]
[NotNull]
public bool IsColumnSet { get; set; }

Property Value

bool

IsComputed

1 = Column is a computed column.
Range: Always 0.

[Column("is_computed")]
[NotNull]
public bool IsComputed { get; set; }

Property Value

bool

IsDtsReplicated

1 = Column is replicated by using SSIS.
Range: Always 0.

[Column("is_dts_replicated")]
[NotNull]
public bool IsDtsReplicated { get; set; }

Property Value

bool

IsFilestream

1 = Column is a FILESTREAM column.
Range: Always 0.

[Column("is_filestream")]
[NotNull]
public bool IsFilestream { get; set; }

Property Value

bool

IsIdentity

1 = Column has identity values.
Range: Always 0.

[Column("is_identity")]
[NotNull]
public bool IsIdentity { get; set; }

Property Value

bool

IsMergePublished

1 = Column is merge-published.
Range: Always 0.

[Column("is_merge_published")]
[NotNull]
public bool IsMergePublished { get; set; }

Property Value

bool

IsNonSqlSubscribed

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

1 = Column is nullable.

[Column("is_nullable")]
[NotNull]
public bool IsNullable { get; set; }

Property Value

bool

IsReplicated

1 = Column is replicated.
Range: Always 0.

[Column("is_replicated")]
[NotNull]
public bool IsReplicated { get; set; }

Property Value

bool

IsRowGuidCol

1 = Column is a declared ROWGUIDCOL.
Range: Always 0.

[Column("is_rowguidcol")]
[NotNull]
public bool IsRowGuidCol { get; set; }

Property Value

bool

IsSparse

1 = Column is a sparse column.
Range: Always 0.

[Column("is_sparse")]
[NotNull]
public bool IsSparse { get; set; }

Property Value

bool

IsXmlDocument

1 = Content is a complete XML document.
Range: Always 0.

[Column("is_xml_document")]
[NotNull]
public bool IsXmlDocument { get; set; }

Property Value

bool

MaxLength

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

ID of the object to which this column belongs.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

PdwNodeID

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 of the column if numeric-based; otherwise, 0.

[Column("precision")]
[NotNull]
public byte Precision { get; set; }

Property Value

byte

RuleObjectID

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 of column if numeric-based; otherwise, 0.

[Column("scale")]
[NotNull]
public byte Scale { get; set; }

Property Value

byte

SystemTypeID

ID of the system type of the column.

[Column("system_type_id")]
[NotNull]
public byte SystemTypeID { get; set; }

Property Value

byte

UserTypeID

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

0 = No XML schema collection.
Range: Always 0.

[Column("xml_collection_id")]
[NotNull]
public int XmlCollectionID { get; set; }

Property Value

int