Jaa


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.

Applies To:

Table Object

 

See Also

Other Resources

ALTER TABLE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance