create rule Restrictions

Restrictions for create rule.

  • You can create a rule only in the current database.

  • Rules do not apply to the data that already exists in the database at the time the rules are created.

  • create rule statements cannot be combined with other statements in a single batch.

  • You cannot bind a rule to an Adaptive-Server-supplied datatype or to a column of type text, unitext, image, or timestamp.

  • You must drop a rule before you create a new one of the same name, and you must unbind a rule before you drop it. Use:
    sp_unbindrule objname [, futureonly]