Export (0) Print
Expand All

AlterTableConstraintModificationStatement Class

Defines modifications to a table constraint.

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

[SerializableAttribute]
public class AlterTableConstraintModificationStatement : AlterTableStatement

The AlterTableConstraintModificationStatement type exposes the following members.

  NameDescription
Public methodAlterTableConstraintModificationStatementInitializes a new instance of the AlterTableConstraintModificationStatement class.
Top

  NameDescription
Public propertyAllGets or sets a value that indicates whether the modification is for all constraints.
Public propertyConstraintEnforcementSets whether the constraint is enabled or disabled. When disabled, future inserts or updates to the column are not validated against the constraint conditions.
Public propertyConstraintNamesGets the names of constraints to be modified. Will have zero elements if All is true.
Public propertyExistingRowsCheckEnforcementGets or sets whether the data in the table is validated against a newly added or re-enabled FOREIGN KEY or CHECK constraint.
Public propertyFirstTokenIndexGets or sets the first token index. (Inherited from TSqlFragment.)
Public propertyFragmentLengthGets the fragment length. (Inherited from TSqlFragment.)
Public propertyLastTokenIndexGets or sets the last token index. (Inherited from TSqlFragment.)
Public propertySchemaObjectNameGets 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 propertyScriptTokenStreamGets or sets a list of token streams. (Inherited from TSqlFragment.)
Public propertyStartColumnGets the starting column. (Inherited from TSqlFragment.)
Public propertyStartLineGets the starting line. (Inherited from TSqlFragment.)
Public propertyStartOffsetGets the fragment start offset value. (Inherited from TSqlFragment.)
Top

  NameDescription
Public methodAcceptAccepts the visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
Public methodAcceptChildrenAccepts the visitor for Children. (Overrides AlterTableStatement.AcceptChildren(TSqlFragmentVisitor).)
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Top

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft