AlterTableConstraintModificationStatement AlterTableConstraintModificationStatement AlterTableConstraintModificationStatement Class

Definition

Defines modifications to a table constraint.

public ref class AlterTableConstraintModificationStatement : Microsoft::SqlServer::TransactSql::ScriptDom::AlterTableStatement
public class AlterTableConstraintModificationStatement : Microsoft.SqlServer.TransactSql.ScriptDom.AlterTableStatement
Public Class AlterTableConstraintModificationStatement
Inherits AlterTableStatement
Inheritance
AlterTableConstraintModificationStatementAlterTableConstraintModificationStatementAlterTableConstraintModificationStatement

Constructors

AlterTableConstraintModificationStatement() AlterTableConstraintModificationStatement() AlterTableConstraintModificationStatement()

Initializes a new instance of the AlterTableConstraintModificationStatement class.

Properties

All All All

Gets or sets a value that indicates whether the modification is for all constraints.

ConstraintEnforcement ConstraintEnforcement ConstraintEnforcement

Sets whether the constraint is enabled or disabled. When disabled, future inserts or updates to the column are not validated against the constraint conditions.

ConstraintNames ConstraintNames ConstraintNames

Gets the names of constraints to be modified. Will have zero elements if All is true.

ExistingRowsCheckEnforcement ExistingRowsCheckEnforcement ExistingRowsCheckEnforcement

Gets or sets whether the data in the table is validated against a newly added or re-enabled FOREIGN KEY or CHECK constraint.

FirstTokenIndex FirstTokenIndex FirstTokenIndex

Gets or sets the first token index.

(Inherited from TSqlFragment)
FragmentLength FragmentLength FragmentLength

Gets the fragment length.

(Inherited from TSqlFragment)
LastTokenIndex LastTokenIndex LastTokenIndex

Gets or sets the last token index.

(Inherited from TSqlFragment)
SchemaObjectName SchemaObjectName SchemaObjectName

Gets or sets the name of the schema to which the table belongs. This can be, at most, a two-part name.

(Inherited from AlterTableStatement)
ScriptTokenStream ScriptTokenStream ScriptTokenStream

Gets or sets a list of token streams.

(Inherited from TSqlFragment)
StartColumn StartColumn StartColumn

Gets the starting column.

(Inherited from TSqlFragment)
StartLine StartLine StartLine

Gets the starting line.

(Inherited from TSqlFragment)
StartOffset StartOffset StartOffset

Gets the fragment start offset value.

(Inherited from TSqlFragment)

Methods

Accept(TSqlFragmentVisitor) Accept(TSqlFragmentVisitor) Accept(TSqlFragmentVisitor)

Accepts the visitor.

AcceptChildren(TSqlFragmentVisitor) AcceptChildren(TSqlFragmentVisitor) AcceptChildren(TSqlFragmentVisitor)

Accepts the visitor for Children.

Fields

Uninitialized Uninitialized Uninitialized

Value is -1.

(Inherited from TSqlFragment)

Applies to