Column Properties window: Value tab

This tab has the following components:

  • No default or computed value   Select this option if the column has no default or computed value.

  • Default value   Select this option if the column has a default value. If the column is based on a domain, this setting inherits the domain's default value (if any), but the value can be overridden for the column. Choosing the Default Value option enables the User-defined and System-defined options.

    • User-defined   Type a custom value (string, number, or other expression) for the default value. If you based the column on a domain, you can retain the domain's default value (if any) or override it for the column. See String and number defaults and Constant expression defaults.

      • Literal string   Specifies whether the default value for the column should be treated as a literal string. This option is selected by default for character columns and domains with a character base type. When you select this option, the default text does not need to be enclosed in single quotes, and you do not need to escape embedded single quotes or backslashes in the string.

        When you clear this option, the automatic quoting and escaping behavior is turned off and the specified default value text is passed as is to the database server.

    • System-defined   Select a pre-defined value (for example, current date) for the default value. You must select a value from the dropdown list. If you based the column on a domain, you can retain the domain's default value (if any) or override it for the column. See Using column defaults.

      • Partition size   When you select global autoincrement for the system-defined value, you can also supply a partition size. See The GLOBAL AUTOINCREMENT default.

  • Computed value   Select this option to define a computed value for the column. A computed column derives its values from calculations of values in other columns. Type an expression in the text box to describe the relationship between the other columns and the value that appears in the computed column. See Working with computed columns.

 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0