Rules Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Rules Editor lets you view or modify basic properties of a rule.

To edit a rule

  1. Open an editor on the rule. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you specify whether the rule is Enabled and view the Fire On Insert, Fire On Update, Fire On Delete, and Encrypted settings.


Lets you view and modify the SQL code that will implement any changes you make using this editor.


For details on using this tab, see Working with Object Dependencies.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.