syscat.out

derby database source code.good for you.

SYSSTATEMENTS                                                                                                                   |SCHEMAID                                                                                                                        |3          |CHAR(36) NOT N&
SYSSTATEMENTS                                                                                                                   |STMTID                                                                                                                          |1          |CHAR(36) NOT N&
SYSSTATEMENTS                                                                                                                   |STMTNAME                                                                                                                        |2          |VARCHAR(128) N&
SYSSTATEMENTS                                                                                                                   |TEXT                                                                                                                            |6          |LONG VARCHAR N&
SYSSTATEMENTS                                                                                                                   |TYPE                                                                                                                            |4          |CHAR(1) NOT NU&
SYSSTATEMENTS                                                                                                                   |USINGTEXT                                                                                                                       |9          |LONG VARCHAR   
SYSSTATEMENTS                                                                                                                   |VALID                                                                                                                           |5          |BOOLEAN NOT NU&
SYSSTATISTICS                                                                                                                   |COLCOUNT                                                                                                                        |7          |INTEGER NOT NU&
SYSSTATISTICS                                                                                                                   |CREATIONTIMESTAMP                                                                                                               |4          |TIMESTAMP NOT &
SYSSTATISTICS                                                                                                                   |REFERENCEID                                                                                                                     |2          |CHAR(36) NOT N&
SYSSTATISTICS                                                                                                                   |STATID                                                                                                                          |1          |CHAR(36) NOT N&
SYSSTATISTICS                                                                                                                   |STATISTICS                                                                                                                      |8          |org.apache.der&
SYSSTATISTICS                                                                                                                   |TABLEID                                                                                                                         |3          |CHAR(36) NOT N&
SYSSTATISTICS                                                                                                                   |TYPE                                                                                                                            |5          |CHAR(1) NOT NU&
SYSSTATISTICS                                                                                                                   |VALID                                                                                                                           |6          |BOOLEAN NOT NU&
SYSTABLES                                                                                                                       |LOCKGRANULARITY                                                                                                                 |5          |CHAR(1) NOT NU&
SYSTABLES                                                                                                                       |SCHEMAID                                                                                                                        |4          |CHAR(36) NOT N&
SYSTABLES                                                                                                                       |TABLEID                                                                                                                         |1          |CHAR(36) NOT N&
SYSTABLES                                                                                                                       |TABLENAME                                                                                                                       |2          |VARCHAR(128) N&
SYSTABLES                                                                                                                       |TABLETYPE                                                                                                                       |3          |CHAR(1) NOT NU&
SYSTRIGGERS                                                                                                                     |ACTIONSTMTID                                                                                                                    |11         |CHAR(36)       
SYSTRIGGERS                                                                                                                     |CREATIONTIMESTAMP                                                                                                               |4          |TIMESTAMP NOT &
SYSTRIGGERS                                                                                                                     |EVENT                                                                                                                           |5          |CHAR(1) NOT NU&
SYSTRIGGERS                                                                                                                     |FIRINGTIME                                                                                                                      |6          |CHAR(1) NOT NU&
SYSTRIGGERS                                                                                                                     |NEWREFERENCINGNAME                                                                                                              |17         |VARCHAR(128)   
SYSTRIGGERS                                                                                                                     |OLDREFERENCINGNAME                                                                                                              |16         |VARCHAR(128)   
SYSTRIGGERS                                                                                                                     |REFERENCEDCOLUMNS                                                                                                               |12         |org.apache.der&
SYSTRIGGERS                                                                                                                     |REFERENCINGNEW                                                                                                                  |15         |BOOLEAN        
SYSTRIGGERS                                                                                                                     |REFERENCINGOLD                                                                                                                  |14         |BOOLEAN        
SYSTRIGGERS                                                                                                                     |SCHEMAID                                                                                                                        |3          |CHAR(36) NOT N&
SYSTRIGGERS                                                                                                                     |STATE                                                                                                                           |8          |CHAR(1) NOT NU&
SYSTRIGGERS                                                                                                                     |TABLEID                                                                                                                         |9          |CHAR(36) NOT N&
SYSTRIGGERS                                                                                                                     |TRIGGERDEFINITION                                                                                                               |13         |LONG VARCHAR   
SYSTRIGGERS                                                                                                                     |TRIGGERID                                                                                                                       |1          |CHAR(36) NOT N&
SYSTRIGGERS                                                                                                                     |TRIGGERNAME                                                                                                                     |2          |VARCHAR(128) N&
SYSTRIGGERS                                                                                                                     |TYPE                                                                                                                            |7          |CHAR(1) NOT NU&
SYSTRIGGERS                                                                                                                     |WHENSTMTID                                                                                                                      |10         |CHAR(36)       
SYSVIEWS                                                                                                                        |CHECKOPTION                                                                                                                     |3          |CHAR(1) NOT NU&
SYSVIEWS                                                                                                                        |COMPILATIONSCHEMAID                                                                                                             |4          |CHAR(36) NOT N&
SYSVIEWS                                                                                                                        |TABLEID                                                                                                                         |1          |CHAR(36) NOT N&
SYSVIEWS                                                                                                                        |VIEWDEFINITION                                                                                                                  |2          |LONG VARCHAR N&
ij> select TABLENAME, ISINDEX 
from sys.systables t, sys.sysconglomerates c
where t.TABLEID=c.TABLEID
order by TABLENAME, ISINDEX;
TABLENAME                                                                                                                       |ISIN&
----------------------------------------------------------------------------------------------------------------------------------