When combined with a User Defined Type a Rule can help ensure that only well formed data is entered into your Database.   This tutorial will show you how to easily manage your Rules using Database Schema Designer.

---

• Add / Edit a Rule

  1. If Adding a new Rule:

     There are a number of methods to create a new Rule Constraint.   Choose the one you are most comfortable with:

     • Open Manage Rules screen and click the "Add" button.   See Manage Schema Objects Tutorial
     • Select "Insert -> Rule" from the main menu.
       
     • Right Click the Schema and select "New -> Rule".
       
     • Right Click the Schema Explorer and select "New -> Rule".
       

     If Editing an existing Rule:

     There are a number of methods to edit an existing Rule Constraint.   Choose the one you are most comfortable with:

     • Open Manage Rule screen and click the "Edit" button with the Rule selected.   See Manage Schema Objects Tutorial
     • Double Click the Rule in the Schema Explorer.
     • Right Click the Rule in the Schema Explorer and select Properties.
       
  2. Editing Rule Properties
     • Type a name for your Rule.
       
     • Type an Owner for your Rule.  ( If required )
       
     • Type the SQL that comprises your Rule.
       
     • Click the    button to log in to your Server and validate the Rule's syntax.  (Not Required)
     • There are a few keyboard shortcuts available for screens that have direct SQL entry.   See SQL Quick Tips
  3. Click OK to submit your changes.
     - OR -
     Click Cancel to discard your settings.
• Delete a Rule

  There are 2 methods to delete a Rule from the Schema.  Choose the one you are most comfortable with:

  • Open the Manage Rules screen and click Delete with the Rule selected.   See Manage Schema Objects Tutorial
  • Using the Schema Explorer, Right Click the Rule and select Delete.