Table of Contents

Class SqlColumn

Namespace
CENTREL.XIA.Configuration.Types
Assembly
CENTREL.XIA.Configuration.Types.dll

Represents a column in a table for a SQL server database.

public class SqlColumn : BaseTypeSection, IComparable<SqlColumn>
Inheritance
SqlColumn
Implements

Constructors

SqlColumn()

Initializes a new instance of the CENTREL.XIA.Configuration.Types.SqlColumn class.

public SqlColumn()

Properties

AllowNulls

Gets or sets whether NULL values are allowed for the column.

public BooleanOption AllowNulls { get; set; }

Property Value

BooleanOption

AnsiPaddingStatus

Gets or sets the ANSI padding status for the column.

public BooleanOption AnsiPaddingStatus { get; set; }

Property Value

BooleanOption

Collation

Gets or sets the collation of the column.

public string Collation { get; set; }

Property Value

string

ComputedText

Gets or sets the computed text for the column.

public string ComputedText { get; set; }

Property Value

string

DataType

Gets or sets the data type of the column.

public SqlInstanceDataType DataType { get; set; }

Property Value

SqlInstanceDataType

DefaultSchema

Gets or sets the default schema for the column.

public string DefaultSchema { get; set; }

Property Value

string

DefaultValue

Gets or sets the default value or binding.

public string DefaultValue { get; set; }

Property Value

string

Description

Gets or sets the description of the column.

public string Description { get; set; }

Property Value

string

ExtendedProperties

Gets or sets the extended properties for the column.

public SqlExtendedProperties ExtendedProperties { get; set; }

Property Value

SqlExtendedProperties

Identifier

Gets or sets the unique identifier for the table. This is for internal use only.

public Guid Identifier { get; set; }

Property Value

Guid

IdentityIncrement

Gets or sets the identity increment. This only applies to identity columns.

public long IdentityIncrement { get; set; }

Property Value

long

IdentitySeed

Gets or sets the identity seed. This only applies to identity columns.

public long IdentitySeed { get; set; }

Property Value

long

InPrimaryKey

Gets or sets whether the column is part of the primary key.

public BooleanOption InPrimaryKey { get; set; }

Property Value

BooleanOption

IsColumnSet

Gets or sets whether the column is a column set.

public BooleanOption IsColumnSet { get; set; }

Property Value

BooleanOption

IsComputed

Gets or sets whether the column is computed.

public BooleanOption IsComputed { get; set; }

Property Value

BooleanOption

IsDeterministic

Gets or sets whether the column is deterministic.

public BooleanOption IsDeterministic { get; set; }

Property Value

BooleanOption

IsForeignKey

Gets or sets whether the column is a foreign key.

public BooleanOption IsForeignKey { get; set; }

Property Value

BooleanOption

IsFullTextIndexed

Gets or sets whether the column is full-text indexed.

public BooleanOption IsFullTextIndexed { get; set; }

Property Value

BooleanOption

IsHidden

Gets or sets whether the column is hidden. This applies to Azure and SQL Server 2016 and above.

public BooleanOption IsHidden { get; set; }

Property Value

BooleanOption

IsIdentity

Gets or sets whether the column is an identity column.

public BooleanOption IsIdentity { get; set; }

Property Value

BooleanOption

IsSparse

Gets or sets whether the column is sparse.

public BooleanOption IsSparse { get; set; }

Property Value

BooleanOption

Name

Gets or sets the name of the column.

public string Name { get; set; }

Property Value

string

NotForReplication

Gets or sets whether the column is not for replication.

public BooleanOption NotForReplication { get; set; }

Property Value

BooleanOption

Methods

Clone()

Returns a CENTREL.XIA.Configuration.Types.SqlColumn cloned from this object.

public SqlColumn Clone()

Returns

SqlColumn

A CENTREL.XIA.Configuration.Types.SqlColumn.

CompareTo(SqlColumn)

Compares two CENTREL.XIA.Configuration.Types.SqlColumn objects to allow sorting alphabetically by name.

public int CompareTo(SqlColumn other)

Parameters

other SqlColumn

The CENTREL.XIA.Configuration.Types.SqlColumn to compare to.

Returns

int

The sort order of the two CENTREL.XIA.Configuration.Types.SqlColumn objects.