Class SqlCreateTableNode

Namespace

LfrlAnvil.Sql.Expressions

Assembly

LfrlAnvil.Sql.Core.dll

Represents an SQL syntax tree statement node that defines creation of a single table.

public sealed class SqlCreateTableNode : SqlNodeBase, ISqlStatementNode

Inheritance

object

SqlNodeBase

SqlCreateTableNode

Implements

ISqlStatementNode

Inherited Members

SqlNodeBase.NodeType

SqlNodeBase.ToString()

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

Extension Methods

SqlNodeExtensions.AsSet(SqlCreateTableNode, string?)

SqlNodeExtensions.ToDropTable(SqlCreateTableNode, bool)

Properties

Checks

Collection of check constraints.

public ReadOnlyArray<SqlCheckDefinitionNode> Checks { get; }

Property Value

ReadOnlyArray<SqlCheckDefinitionNode>

Columns

Collection of columns.

public ReadOnlyArray<SqlColumnDefinitionNode> Columns { get; }

Property Value

ReadOnlyArray<SqlColumnDefinitionNode>

ForeignKeys

Collection of foreign key constraints.

public ReadOnlyArray<SqlForeignKeyDefinitionNode> ForeignKeys { get; }

Property Value

ReadOnlyArray<SqlForeignKeyDefinitionNode>

IfNotExists

Specifies whether or not this table should only be created if it does not already exist in DB.

public bool IfNotExists { get; }

Property Value

bool

Info

Table's name.

public SqlRecordSetInfo Info { get; }

Property Value

SqlRecordSetInfo

PrimaryKey

Optional primary key constraint.

public SqlPrimaryKeyDefinitionNode? PrimaryKey { get; }

Property Value

SqlPrimaryKeyDefinitionNode

RecordSet

Underlying SqlRecordSetNode instance associated with this node.

public SqlNewTableNode RecordSet { get; }

Property Value

SqlNewTableNode