Creating a Rule

Create a rule that specifies the domain of acceptable values for a particular column.

Only a database owner, or a user or group with create rule permission can create a rule.
  1. In the left pane of Administration Console, expand ASE Servers > Compiled Objects, then select Rules.
  2. Click the drop-down arrow and select New.
    You see the Create Rule wizard.
  3. On the Introduction screen, select the server, database, and owner of the new rule.
  4. Enter the name of the rule.
  5. Enter the expression that is used to evaluate the data. You can use any expression that is valid in a where clause.
  6. (Optional) Click Preview to see the SQL statements for your command.
  7. (Optional) Click Summary to verify your selected options.
Parent topic: Manage Rules
Related reference
Rule Properties