Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » Context-Sensitive Help » SQL Anywhere plug-in help » SQL Anywhere properties windows


Column Properties window: Data Type tab

This tab has the following components:

  • Built-in type   This option enables you to choose a built-in data type for the column from the dropdown list. Integers, character strings, and dates are examples of built-in data types. For some of these types, you can specify size and/or scale:

    Size Specifies the length of string columns, or the total number of digits to the left and right of the decimal point in the result of any decimal arithmetic for numeric columns. For numeric columns, the size is also called the precision value. See precision option.

    Displays the unit corresponding to the data type's size. Possible units include: bits, bytes, characters, or digits.

    For CHAR and VARCHAR data types, you can specify the unit as bytes or characters.

    Scale Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum precision value. See SQL data types.
    • Set Spatial Reference System   Select this option to specify the spatial reference system. This option is available when you specify a spatial data type (such as ST_Point or ST_Polygon) in the Built-in Type field.

  • Domain   Select this option to choose a domain from the dropdown list. A domain is a named combination of built-in data types, default value, check condition, and nullability.

  • Java class   This option is only shown for version 8.0.x databases. Select this option to choose a Java class for the column from the dropdown list.

  • Compress values   Select this option to compress column values. Note that if a column is compressed, database server activities such as indexing, data comparisons, and statistics generation may be slightly slower if they involve the compressed column because the values must be compressed when written, and decompressed when read.

  • Maintain BLOB indexes for large values   Select this option to maintain BLOB indexes for large values. Only character, binary, and bit types support this option. See CREATE TABLE statement.

 See also