AlterTableConstraintModificationStatement Class

Definition

Defines modifications to a table constraint.

[System.Serializable]
public class AlterTableConstraintModificationStatement : Microsoft.SqlServer.TransactSql.ScriptDom.AlterTableStatement
[<System.Serializable>]
type AlterTableConstraintModificationStatement = class
    inherit AlterTableStatement
Public Class AlterTableConstraintModificationStatement
Inherits AlterTableStatement
Inheritance
AlterTableConstraintModificationStatement
Attributes

Constructors

AlterTableConstraintModificationStatement()

Fields

Uninitialized

Constant to indicate and uninitialized token.

(Inherited from TSqlFragment)

Properties

All

True if the modification is for all constraints.

ConstraintEnforcement

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

ConstraintNames

Names of constraints to be modified. Will have zero elements if All is true.

ExistingRowsCheckEnforcement

Specifies whether the data in the table is or is not validated against a newly added or re-enabled FOREIGN KEY or CHECK constraint. Defines which one of WITH CHECK or WITH NOCHECK were used. No Check is the default for this class(if nothing was explicitly mentioned), since these are reenabled constraints (Books online).

FirstTokenIndex

Gets or sets the first index of the token.

(Inherited from TSqlFragment)
FragmentLength

Defines the number of characters the fragment takes up in the script it was parsed.

(Inherited from TSqlFragment)
LastTokenIndex

Gets or sets the last index of the token.

(Inherited from TSqlFragment)
SchemaObjectName

The name of the type, this can be at most a two part name.

(Inherited from AlterTableStatement)
ScriptTokenStream

Gets or sets the script token stream.

(Inherited from TSqlFragment)
StartColumn

Gets the start column.

(Inherited from TSqlFragment)
StartLine

Gets the start line.

(Inherited from TSqlFragment)
StartOffset

Defines the character offset of fragments starting location in the script it was parsed.

(Inherited from TSqlFragment)

Methods

Accept(TSqlFragmentVisitor)

Accepts visitor

AcceptChildren(TSqlFragmentVisitor)

Accepts visitor for Children

Applies to