Class SqlTable

Namespace

CENTREL.XIA.Configuration.Types

Assembly

CENTREL.XIA.Configuration.Types.dll

Represents a table for a SQL server database.

public class SqlTable : BaseTypeSection, IComparable<SqlTable>

Inheritance

object

BaseTypeSection

SqlTable

Implements

IComparable<SqlTable>

Constructors

SqlTable()

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

public SqlTable()

Properties

AnsiNullsStatus

Gets or sets the ANSI NULLs status for the database.

public BooleanOption AnsiNullsStatus { get; set; }

Property Value

BooleanOption

ChangeTrackingEnabled

Gets or sets whether change tracking is enabled for the table. This applies to Azure and SQL Server 2012 and above.

public BooleanOption ChangeTrackingEnabled { get; set; }

Property Value

BooleanOption

Collation

Gets or sets the collation of the table.

public string Collation { get; set; }

Property Value

string

Columns

Gets or sets the columns defined for the table.

public SqlColumns Columns { get; set; }

Property Value

SqlColumns

CreationScript

Gets or sets the SQL script used to create the table.

public SqlScript CreationScript { get; set; }

Property Value

SqlScript

DateCreated

Gets or sets the date and time the user defined function was created.

public DateTime DateCreated { get; set; }

Property Value

DateTime

DateLastModified

Gets or sets the date and time the table was last modified.

public DateTime DateLastModified { get; set; }

Property Value

DateTime

Description

Gets or sets the description of the table.

public string Description { get; set; }

Property Value

string

DisplayStatus

Gets or sets the display status of the table.

public string DisplayStatus { get; set; }

Property Value

string

Durability

Gets or sets the durability type of the table. This applies to Azure and SQL Server 2016 and above.

public SqlTableDurabilityType Durability { get; set; }

Property Value

SqlTableDurabilityType

ExtendedProperties

Gets or sets the extended properties for the database table.

public SqlExtendedProperties ExtendedProperties { get; set; }

Property Value

SqlExtendedProperties

ForeignKeys

Gets or sets the foreign keys defined for the database.

public SqlForeignKeys ForeignKeys { get; set; }

Property Value

SqlForeignKeys

Identifier

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

public Guid Identifier { get; set; }

Property Value

Guid

IsEdge

Gets or sets whether the table is a graph edge table. This applies to Azure and SQL Server 2017 and above.

public BooleanOption IsEdge { get; set; }

Property Value

BooleanOption

IsMemoryOptimized

Gets or sets whether the table is memory optimized. This applies to Azure and SQL Server 2014 and above.

public BooleanOption IsMemoryOptimized { get; set; }

Property Value

BooleanOption

IsNode

Gets or sets whether the table is a graph node table. This applies to Azure and SQL Server 2017 and above.

public BooleanOption IsNode { get; set; }

Property Value

BooleanOption

IsSystemObject

Gets or sets whether the table is a system object.

public BooleanOption IsSystemObject { get; set; }

Property Value

BooleanOption

Name

Gets or sets the name of the table.

public string Name { get; set; }

Property Value

string

QuotedIdentifierStatus

Gets or sets the quoted identifier status for the table.

public BooleanOption QuotedIdentifierStatus { get; set; }

Property Value

BooleanOption

Replicated

Gets or sets whether the table is replicated.

public BooleanOption Replicated { get; set; }

Property Value

BooleanOption

Schema

Gets or sets the schema of the table.

public string Schema { get; set; }

Property Value

string

Storage

Gets or sets the storage settings for the table. This applies to on-premises SQL instances.

public SqlTableStorageSettings Storage { get; set; }

Property Value

SqlTableStorageSettings

TemporalType

Gets or sets the temporal type for the table. This applies to Azure and SQL Server 2016 and above.

public SqlTableTemporalType TemporalType { get; set; }

Property Value

SqlTableTemporalType

TrackColumnsUpdatedEnabled

Gets or sets whether to track column updates as part of change tracking. This applies to Azure and SQL Server 2012 and above.

public BooleanOption TrackColumnsUpdatedEnabled { get; set; }

Property Value

BooleanOption

Triggers

Gets or sets the triggers defined for the table.

public SqlTriggers Triggers { get; set; }

Property Value

SqlTriggers

Methods

Clone()

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

public SqlTable Clone()

Returns

SqlTable

A CENTREL.XIA.Configuration.Types.SqlTable.

CompareTo(SqlTable)

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

public int CompareTo(SqlTable other)

Parameters

other SqlTable

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

Returns

int

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

ToString()

Returns the name of the table.

public override string ToString()

Returns

string

The name of the table.