syscat.out

derby database source code.good for you.

ij> select TABLENAME,
	COLUMNNAME, COLUMNNUMBER,
	columndatatype
from sys.systables t, sys.syscolumns c
where t.TABLEID=c.REFERENCEID
order by TABLENAME, COLUMNNAME;
TABLENAME |COLUMNNAME |COLUMNNUMB& |COLUMNDATATYPE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
-----
SYSALIASES |ALIAS |2 |VARCHAR(128) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
SYSALIASES |ALIASID |1 |CHAR(36) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
SYSALIASES |ALIASINFO |8 |org.apache.derby.catalog.AliasInfo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
SYSALIASES |ALIASTYPE |5 |CHAR(1) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
SYSALIASES |JAVACLASSNAME |4 |LONG VARCHAR NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
SYSALIASES |NAMESPACE |6 |CHAR(1) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
SYSALIASES |SCHEMAID |3 |CHAR(36)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
SYSALIASES |SPECIFICNAME |9 |VARCHAR(128) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
SYSALIASES |SYSTEMALIAS |7 |BOOLEAN NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
SYSCHECKS |CHECKDEFINITION |2 |LONG VARCHAR NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
SYSCHECKS |CONSTRAINTID |1 |CHAR(36) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
SYSCHECKS |REFERENCEDCOLUMNS |3 |org.apache.derby.catalog.ReferencedColumns NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
SYSCOLUMNS |AUTOINCREMENTINC |9 |BIGINT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
SYSCOLUMNS |AUTOINCREMENTSTART |8 |BIGINT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
SYSCOLUMNS |AUTOINCREMENTVALUE |7 |BIGINT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
SYSCOLUMNS |COLUMNDATATYPE |4 |org.apache.derby.catalog.TypeDescriptor NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
SYSCOLUMNS |COLUMNDEFAULT |5 |java.io.Serializable                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
SYSCOLUMNS |COLUMNDEFAULTID |6 |CHAR(36)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
SYSCOLUMNS |COLUMNNAME |2 |VARCHAR(128) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
SYSCOLUMNS |COLUMNNUMBER |3 |INTEGER NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
SYSCOLUMNS |REFERENCEID |1 |CHAR(36) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
SYSCONGLOMERATES |CONGLOMERATEID |8 |CHAR(36) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
SYSCONGLOMERATES |CONGLOMERATENAME |4 |VARCHAR(128)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
SYSCONGLOMERATES |CONGLOMERATENUMBER |3 |BIGINT NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
SYSCONGLOMERATES |DESCRIPTOR |6 |org.apache.derby.catalog.IndexDescriptor                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
SYSCONGLOMERATES |ISCONSTRAINT |7 |BOOLEAN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
SYSCONGLOMERATES |ISINDEX |5 |BOOLEAN NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
SYSCONGLOMERATES |SCHEMAID |1 |CHAR(36) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
SYSCONGLOMERATES |TABLEID |2 |CHAR(36) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
SYSCONSTRAINTS |CONSTRAINTID |1 |CHAR(36) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
SYSCONSTRAINTS |CONSTRAINTNAME |3 |VARCHAR(128) NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
SYSCONSTRAINTS |REFERENCECOUNT |7 |INTEGER NOT NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
SYSCONSTRAINTS |SCHEMAID |5 |CHAR(36) NOT NULL