Creating a Default

Specify a value to insert in a column if no value is explicitly supplied at insert time.

  1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects, then select Defaults.
  2. Click the drop-down arrow and select New.
  3. On the Introduction screen, select the server, database, and owner of the new default.
  4. Enter the name of the default.
  5. Enter the expression to define the value of the default. Expressions must be constants, mathematical expressions, or built-in functions.
  6. (Optional) Click Summary to verify your selected options.