This section describes the attribute types for a table.
Not all JDBC attribute types are implemented by all databases. Using an unsupported type will result in errors during table creation. In addition, databases often implement types in slightly different ways, so the descriptions below may not be accurate in all cases.
bigint
This type is used to represent 64-bit signed integers.
integer
This type is used to represent 32-bit signed integers.
smallint
This type is used to represent 16-bit signed integers.
tinyint
This type is used to represent 8-bit integers that may be signed or unsigned.
bit
This type is used to represent an integer with a value of 1 (True) or 0 (False).
decimal
This type is used to represent fixed precision and scale numeric data with at least the specified precision.
numeric
This type is used to represent fixed precision and scale numeric data with exactly the specified precision.
double
This type is used to represent 64-bit floating precision numbers.
real
This type is used to represent 32-bit floating precision numbers.
date
This type is used to represent dates.
time
This type is used to represent times.
timestamp
This type is used to represent date and time data.
char
This type is used to represent fixed-length character data.
varchar
This type is used to represent variable-length character data.
clob
This type is used to represent large amounts of variable-length character data.
nchar
This type is used to represent fixed-length international character data.
nvarchar
This type is used to represent variable-length international character data.
nclob
This type is used to represent large amounts of variable-length international character data.
binary
This type is used to represent fixed-length binary data.
varbinary
This type is used to represent variable-length binary data.
blob
This type is used to represent large amounts of variable-length binary data.
The type of index or constraint to create for the column. Indexes and constraints are only created if the table is created.
The valid values for the column type are listed below:
PrimaryKey: Create a Primary Key index on the column.
Unique: Only one of each non-null value is allowed in the column.
NotNull: Nulls are not allowed in the column.
UniqueNotNull: Only one of each value is allowed in the column. Nulls are not allowed.