• 發行項

CheckRuleSyntax Method

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。

The CheckRuleSyntax method validates the syntax of a Transact-SQL database rule prior to creating it.

語法

object.CheckRuleSyntax(Rule)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

  • Rule
    A Rule object.

Prototype (C/C++)

HRESULT CheckRuleSyntax(LPSQLDMORULE Rule);

備註

Database defaults and rules cannot be modified once they are created. They must first be dropped and then recreated. An application can call the CheckDefaultSyntax or CheckRuleSyntax method to validate the syntax of a Transact-SQL database rule prior to its creation.

An application might call the CheckDefaultSyntax method or CheckRuleSyntax method in a scenario in which a rule or default already exists, and it is necessary to change the definition (specified by the Text property). The application:

  1. Creates a new rule or default object.

  2. Sets the Name property of the new object to the name of the existing object.

  3. Sets the Text property of the new object to define the default or rule.

  4. Calls CheckDefaultSyntax method or CheckRuleSyntax method to verify the syntax of the Text Property.

  5. Drops the existing object and recreates it using the new object if CheckDefaultSyntax method or CheckRuleSyntax method returns TRUE.

  6. CheckDefaultSyntax method returns TRUE if the Transact-SQL syntax is valid.

Applies to:

Database2 Object

請參閱

參考

CheckDefaultSyntax Method