DoAlterWithNoCheck Method

SQL-DMO

SQL-DMO

DoAlterWithNoCheck Method

The DoAlterWithNoCheck method marks the end of a unit of change for the object referenced and submits changes made to property values.

Applies To
Table Object  
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-DMO to create constraints on existing tables, use DoAlterWithNoCheck to force WITH NOCHECK behavior and optimize constraint implementation.

See Also

ALTER TABLE