SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
Column property sheet
The Data Type tab of the Column property sheet has the following components:
Built-in type Select this option to choose a predefined data type for the column from the dropdown list. Integers, character strings, and dates are examples of predefined 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.
For more information about the PRECISION value, see PRECISION option [database].
Scale Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum PRECISION value.
For more information about data types, 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. If the database does not support Java, this option is not enabled.
Choosing data types for columns