Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 | |
|---|---|---|
.gif "Public method") |
AlterTableConstraintModificationStatement | Initializes a new instance of the AlterTableConstraintModificationStatement class. |
Top
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
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.) |
.gif "Protected method") |
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.