DoAlterWithNoCheck Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The DoAlterWithNoCheck method marks the end of a unit of change for the object referenced and submits changes made to property values.
Syntax
object.DoAlterWithNoCheck( )
Parts
- object
Expression that evaluates to an object in the Applies To list.
Prototype (C/C++)
HRESULT DoAlterWithNoCheck( );
Remarks
The WITH NOCHECK clause of the Transact-SQL ALTER TABLE statement disables existing value check when adding a constraint to a table containing data, optimizing constraint implementation. When using SQL Distributed Management Objects (SQL-DMO) to create constraints on existing tables, use DoAlterWithNoCheck to force WITH NOCHECK behavior and optimize constraint implementation.