Binding Defaults and Rules to a Column

Specify constraints on column data by binding defaults or rules to a column.

Make sure that any default value bound to a column or user-defined datatype is compatible with the rule. A default that conflicts with the rule is not inserted.

You cannot bind a rule to a text, image, or timestamp column.

Rules bound to columns take precedence over rules bound to user-defined datatypes.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  2. Click the Name field of the table, then click the drop-down arrow and select Properties.
  3. In the left pane, click Columns.
  4. Click the Name field of the column, then click the drop-down arrow and select Properties.
  5. In the left pane, Rules and Defaults.
  6. Choose one of:
    • Default – None.
    • Default – Binding to bind an existing default to the column.
    • Default – Value to bind a default user, defined value to the column.
    • Rule Binding to bind an existing rule to a column.
  7. Click Apply to apply your rules or defaults.
Related tasks
Creating a Check Constraint
Creating a Unique Constraint or Primary Key
Creating a Foreign Key