AlterTableConstraintModificationStatement Class

Reference

Definition

Namespace:: Microsoft.SqlServer.TransactSql.ScriptDom

Assembly:: Microsoft.SqlServer.TransactSql.ScriptDom.dll

Package:: Microsoft.SqlServer.DacFx.x64 v140.3881.1

Package:: Microsoft.SqlServer.DacFx v150.5282.3

Package:: Microsoft.SqlServer.DacFx v160.6161.0

Package:: Microsoft.Data.Tools.Msbuild v10.0.61804.210

Package:: Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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: Object

TSqlFragment

TSqlStatement

AlterTableStatement
AlterTableConstraintModificationStatement

Attributes: SerializableAttribute

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

Compartilhar via