# 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

Parent topic: Derby System Tables
Related reference
SYSALIASES
SYSCHECKS
SYSCOLPERMS
SYSCONGLOMERATES
SYSCONSTRAINTS
SYSDEPENDS
SYSFILES
SYSFOREIGNKEYS
SYSKEYS
SYSROUTINEPERMS
SYSSCHEMAS
SYSSTATISTICS
SYSSTATEMENTS
SYSTABLEPERMS
SYSTABLES
SYSTRIGGERS
SYSVIEWS