DoAlterWithNoCheck Method (SQL-DMO)

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()

Part Description
object Expression that evaluates to an object in the Applies To list

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.

Prototype (C/C++)

HRESULT DoAlterWithNoCheck();

See Also

ALTER TABLE

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.