UltraLite Database User's Guide
  Utility Programs
    The UltraLite Schema Painter
      UltraLite Schema Painter dialogs

New Column property sheet: General tab

The General tab of the New Column property sheet has the following components:

• Name    Enter a name for the column.

• Type    Select a datatype from the dropdown list.

  • Size/Precision    Specify the size of the column for binary or char types, or the precision for numeric types.

  • Scale    Specify the scale value for a numeric column.

• Column allows null values    Check this option to allow null values. Null values are not permitted in primary keys.

• Column default    Set a default value for the column.

  • Default    Select a default value for the column from the list, or choose Specify value... to set a constant value.

  • Value    Specify the column value. This option is only available when Specify value is selected as the default value.

  • Partition size (optional)    Specify the partition size. The partition size restricts the maximum value that global autoincrement can use. This option is only available when Global autoincrement is selected as the default value.