syscat.out

derby database source code.good for you.

SYSSCHEMAS_INDEX2                                                                                                               |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }                                                                                                                                                                                                                                                                                                                                            
SYSSTATEMENTS_INDEX1                                                                                                            |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }                                                                                                                                                                                                                                                                                                                                            
SYSSTATEMENTS_INDEX2                                                                                                            |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }                                                                                                                                                                                                                                                                                                                                            
SYSSTATISTICS_INDEX1                                                                                                            |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }                                                                                                                                                                                                                                                                                                                                            
SYSTABLES_INDEX1                                                                                                                |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }                                                                                                                                                                                                                                                                                                                                            
SYSTABLES_INDEX2                                                                                                                |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }                                                                                                                                                                                                                                                                                                                                            
SYSTRIGGERS_INDEX1                                                                                                              |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }                                                                                                                                                                                                                                                                                                                                            
SYSTRIGGERS_INDEX2                                                                                                              |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }                                                                                                                                                                                                                                                                                                                                            
SYSTRIGGERS_INDEX3                                                                                                              |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }                                                                                                                                                                                                                                                                                                                                            
SYSVIEWS_INDEX1                                                                                                                 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }                                                                                                                                                                                                                                                                                                                                            
ij> select TABLENAME, TABLETYPE from sys.systables;
TABLENAME                                                                                                                       |&
----------------------------------------------------------------------------------------------------------------------------------
SYSCONGLOMERATES                                                                                                                |S
SYSTABLES                                                                                                                       |S
SYSCOLUMNS                                                                                                                      |S
SYSSCHEMAS                                                                                                                      |S
SYSCONSTRAINTS                                                                                                                  |S
SYSKEYS                                                                                                                         |S
SYSDEPENDS                                                                                                                      |S
SYSALIASES                                                                                                                      |S
SYSVIEWS                                                                                                                        |S
SYSCHECKS                                                                                                                       |S
SYSFOREIGNKEYS                                                                                                                  |S
SYSSTATEMENTS                                                                                                                   |S
SYSFILES                                                                                                                        |S
SYSTRIGGERS                                                                                                                     |S
SYSSTATISTICS                                                                                                                   |S
SYSDUMMY1                                                                                                                       |S
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) N&
SYSALIASES                                                                                                                      |ALIASID                                                                                                                         |1          |CHAR(36) NOT N&
SYSALIASES                                                                                                                      |ALIASINFO                                                                                                                       |8          |org.apache.der&
SYSALIASES                                                                                                                      |ALIASTYPE                                                                                                                       |5          |CHAR(1) NOT NU&
SYSALIASES                                                                                                                      |JAVACLASSNAME                                                                                                                   |4          |LONG VARCHAR N&
SYSALIASES                                                                                                                      |NAMESPACE                                                                                                                       |6          |CHAR(1) NOT NU&
SYSALIASES                                                                                                                      |SCHEMAID                                                                                                                        |3          |CHAR(36)       
SYSALIASES                                                                                                                      |SPECIFICNAME                                                                                                                    |9          |VARCHAR(128) N&
SYSALIASES                                                                                                                      |SYSTEMALIAS                                                                                                                     |7          |BOOLEAN NOT NU&
SYSCHECKS                                                                                                                       |CHECKDEFINITION                                                                                                                 |2          |LONG VARCHAR N&