<< SYSCOLUMNS system table | SYSCONGLOMERATES system table >>

COLUMNDATATYPE

<< SYSCOLUMNS system table | SYSCONGLOMERATES system table >>

Derby Reference Manual

223

Column Name

Type

Length

Nullable

Contents

COLUMNNUMBER

INT

false

The position of the
column within the
table

COLUMNDATATYPE

org.apache.derby.
catalog.
TypeDescriptor

This class is not
part of the public
API.

2,147,483,647

false

System type
that describes
precision, length,
scale, nullability,
type name, and
storage type
of data. For a
user-defined
type, this column
can hold a
TypeDescriptor
that refers to the
appropriate type
alias in SYS.SYSALIASES.

COLUMNDEFAULT

java.io.Serializable

2,147,483,647

true

For tables,
describes default
value of the
column. The
toString() method
on the object
stored in the table
returns the text of
the default value
as specified in the
CREATE TABLE
or ALTER TABLE
statement.

COLUMNDEFAULTID

CHAR

true

Unique identifier for
the default value

AUTOINCREMENTVALUE

BIGINT

true

What the next
value for column
will be, if the
column is an
identity column

AUTOINCREMENTSTART

BIGINT

true

Initial value
of column (if
specified), if it is an
identity column

AUTOINCREMENTINC

BIGINT

true

Amount
column value
is automatically
incremented (if
specified), if the
column is an
identity column