Binding Defaults and Rules to a Column

Specify constraints on column data by binding defaults or rule 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. Select ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  2. Select Properties.
  3. Click Columns.
  4. Select a column, then select Properties.
  5. Click 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.
Parent topic: Manage Tables
Related tasks
Creating a Check Constraint
Creating a Unique Constraint
Creating a Primary Key
Creating a Foreign Key