Export (0) Print
Expand All

Rule Property

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 Rule property identifies a data integrity constraint, implemented by a Microsoft SQL Server database rule and bound to the referenced column or user-defined data type.


object
.Rule [= value]

object

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

value

A string that identifies a SQL Server rule by name

String

Read/write for the Column object. Read-only for the UserDefinedDatatype object.

HRESULT GetRule(SQLDMO_LPBSTR pRetVal);
HRESULT SetRule(SQLDMO_LPCSTR NewValue);
ms131547.note(en-US,SQL.90).gifNote:
SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

Setting the Rule property offers an alternate method for binding SQL Server rules to columns.

Community Additions

ADD
Show:
© 2014 Microsoft