Checked Property

后续版本的 Microsoft SQL Server 将删除该功能。 请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。

The Checked property enables or disables integrity or FOREIGN KEY constraint evaluation for an existing integrity or FOREIGN KEY constraint.

语法

object.Checked [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write when the SQL Distributed Management Objects (SQL-DMO) object references an existing Microsoft SQL Server component.

Prototype (C/C++)

HRESULT GetChecked(LPBOOL pRetVal);
HRESULT SetChecked(BOOL NewValue);

注释

If TRUE, an attempt is made to enforce an integrity or FOREIGN KEY constraint when rows are added to the table on which the constraint is defined. An error occurs if data fails constraint checking.

If FALSE, no attempt is made to enforce the integrity or FOREIGN KEY constraint when rows are added to the table on which the constraint is defined.

Applies To:

请参阅

参考