Table of Contents

Class SqlForeignKeyDefinitionNode

Namespace
LfrlAnvil.Sql.Expressions
Assembly
LfrlAnvil.Sql.Core.dll

Represents an SQL syntax tree node that defines a foreign key constraint.

public sealed class SqlForeignKeyDefinitionNode : SqlNodeBase
Inheritance
SqlForeignKeyDefinitionNode
Inherited Members

Properties

Columns

Collection of columns from source table that this foreign key originates from.

public ReadOnlyArray<SqlDataFieldNode> Columns { get; }

Property Value

ReadOnlyArray<SqlDataFieldNode>

Name

Foreign key constraint's name.

public SqlSchemaObjectName Name { get; }

Property Value

SqlSchemaObjectName

OnDeleteBehavior

Specifies this foreign key constraint's on delete behavior.

public ReferenceBehavior OnDeleteBehavior { get; }

Property Value

ReferenceBehavior

OnUpdateBehavior

Specifies this foreign key constraint's on update behavior.

public ReferenceBehavior OnUpdateBehavior { get; }

Property Value

ReferenceBehavior

ReferencedColumns

Collection of columns from ReferencedTable referenced by this foreign key constraint.

public ReadOnlyArray<SqlDataFieldNode> ReferencedColumns { get; }

Property Value

ReadOnlyArray<SqlDataFieldNode>

ReferencedTable

Table referenced by this foreign key constraint.

public SqlRecordSetNode ReferencedTable { get; }

Property Value

SqlRecordSetNode