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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » SQL Anywhere Plug-in Help » Introduction to SQL Anywhere property sheets

Column property sheet: General tab Next Page

Column property sheet: Data Type tab

The Data Type tab of the Column property sheet 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:

See SQL Data Types.

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    Select this option to choose a Java class for the column from the dropdown list. This option is only shown for version 8.0.x databases.

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.

See Choosing whether to compress columns.

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