Partager via

  • Article

Rule Property

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The Ruleproperty identifies a data integrity constraint, implemented by a Microsoft SQL Server database rule and bound to the referenced column or user-defined data type.

Syntaxe

object.Rule [= value]

Parts

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

  • value
    A string that identifies a SQL Server rule by name

Data Type

String

Modifiable

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

Prototype (C/C++)

HRESULT GetRule(SQLDMO_LPBSTR pRetVal);
HRESULT SetRule(SQLDMO_LPCSTR NewValue);

[!REMARQUE]

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.

Notes

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