This topic has not yet been rated - Rate this topic

AlterTableConstraintModificationStatement Class

SQL Server 2012

Defines modifications to a table constraint.

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
      Microsoft.SqlServer.TransactSql.ScriptDom.AlterTableStatement
        Microsoft.SqlServer.TransactSql.ScriptDom.AlterTableConstraintModificationStatement

Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Syntax

C++

JScript

[<SerializableAttribute>]
type AlterTableConstraintModificationStatement =  
    class 
        inherit AlterTableStatement 
    end

The AlterTableConstraintModificationStatement type exposes the following members.

Constructors

	Name	Description
	AlterTableConstraintModificationStatement	Initializes a new instance of the AlterTableConstraintModificationStatement class.

Top

Properties

	Name	Description
	All	Gets or sets a value that indicates whether the modification is for all constraints.
	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	Gets the names of constraints to be modified. Will have zero elements if All is true.
	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	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	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	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	StartColumn	Gets the starting column. (Inherited from TSqlFragment.)
	StartLine	Gets the starting line. (Inherited from TSqlFragment.)
	StartOffset	Gets the fragment start offset value. (Inherited from TSqlFragment.)

Top

Methods

	Name	Description
	Accept	Accepts the visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
	AcceptChildren	Accepts the visitor for Children. (Overrides AlterTableStatement.AcceptChildren(TSqlFragmentVisitor).)
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	ToString	(Inherited from Object.)

Top

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Reference

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD