AlterTableConstraintModificationStatement Class

  • Article

Defines modifications to a table constraint.

Inheritance Hierarchy

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

'Declaration
<SerializableAttribute> _
Public Class AlterTableConstraintModificationStatement _
    Inherits AlterTableStatement
'Usage
Dim instance As AlterTableConstraintModificationStatement

[SerializableAttribute]
public class AlterTableConstraintModificationStatement : AlterTableStatement

[SerializableAttribute]
public ref class AlterTableConstraintModificationStatement : public AlterTableStatement

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

public class AlterTableConstraintModificationStatement extends AlterTableStatement

The AlterTableConstraintModificationStatement type exposes the following members.

Constructors

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

Top

Properties

  Name Description
Public property All Gets or sets a value that indicates whether the modification is for all constraints.
Public property 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.
Public property ConstraintNames Gets the names of constraints to be modified. Will have zero elements if All is true.
Public property ExistingRowsCheckEnforcement Gets or sets whether the data in the table is validated against a newly added or re-enabled FOREIGN KEY or CHECK constraint.
Public property FirstTokenIndex Gets or sets the first token index. (Inherited from TSqlFragment.)
Public property FragmentLength Gets the fragment length. (Inherited from TSqlFragment.)
Public property LastTokenIndex Gets or sets the last token index. (Inherited from TSqlFragment.)
Public property 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.)
Public property ScriptTokenStream Gets or sets a list of token streams. (Inherited from TSqlFragment.)
Public property StartColumn Gets the starting column. (Inherited from TSqlFragment.)
Public property StartLine Gets the starting line. (Inherited from TSqlFragment.)
Public property StartOffset Gets the fragment start offset value. (Inherited from TSqlFragment.)

Top

Methods

  Name Description
Public method Accept Accepts the visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
Public method AcceptChildren Accepts the visitor for Children. (Overrides AlterTableStatement.AcceptChildren(TSqlFragmentVisitor).)
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method 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.

See Also

Reference

Microsoft.SqlServer.TransactSql.ScriptDom Namespace