SYSCOLUMNS

Describes the columns within all tables in the current database: Column Name Type Length Nullable Contents REFERENCEID CHAR 36 false Identifier for table (join with SYSTABLES.TABLEID) COLUMNNAME CHAR 128 false column or parameter name COLUMNNUMBER INT 4 false the position of the column within the table COLUMNDATATYPE org.apache.derby.catalog. TypeDescriptor

This class is not part of the public API.

false system type that describes precision, length, scale, nullability, type name, and storage type of data
COLUMNDEFAULT java.io.Serializable 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 36 true unique identifier for the default value AUTOINCREMENT COLUMNVALUE BIGINT true what the next value for column will be, if the column is an identity column AUTOINCREMENT COLUMNSTART BIGINT true initial value of column (if specified), if it is an identity column AUTOINCREMENT COLUMNINC BIGINT true amount column value is automatically incremented (if specified), if the column is an identity column