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 Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
  2. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  3. Select Properties.
  4. Click Columns.
  5. Select a column, then select Properties.
  6. Click Rules and Defaults.
  7. 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.
  8. Click Apply to apply your rules or defaults.
Parent topic: Manage Tables
Related tasks
Creating a Check Constraint
Creating a Unique Constraint
Creating a Primary Key
Creating a Foreign Key