Table SYSTEM_TABLETYPES() {

        Table t = sysTables[SYSTEM_TABLETYPES];

        if (t == null) {
            t = createBlankTable(sysTableHsqlNames[SYSTEM_TABLETYPES]);

            addColumn(t, "TABLE_TYPE", SQL_IDENTIFIER);    // not null

            // order: TABLE_TYPE
            // true PK
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_TABLETYPES].name, false,
                SchemaObject.INDEX);

            t.createPrimaryKey(name, new int[]{ 0 }, true);

            return t;
        }

        PersistentStore store = database.persistentStoreCollection.getStore(t);
        Object[]        row;

        for (int i = 0; i < tableTypes.length; i++) {
            row    = t.getEmptyRowData();
            row[0] = tableTypes[i];

            t.insertSys(store, row);
        }

        return t;
    }
Table SYSTEM_TABLETYPES ( ) { Table t = sysTables [ SYSTEM_TABLETYPES ] ; if ( t == null ) { t = createBlankTable ( sysTableHsqlNames [ SYSTEM_TABLETYPES ] ) ; addColumn ( t , "TABLE_TYPE" , SQL_IDENTIFIER ) ; HsqlName name = HsqlNameManager . newInfoSchemaObjectName ( sysTableHsqlNames [ SYSTEM_TABLETYPES ] . name , false , SchemaObject . INDEX ) ; t . createPrimaryKey ( name , new int [ ] { 0 } , true ) ; return t ; } PersistentStore store = database . persistentStoreCollection . getStore ( t ) ; Object [ ] row ; for ( int i = 0 ; i < tableTypes . length ; i ++ ) { row = t . getEmptyRowData ( ) ; row [ 0 ] = tableTypes [ i ] ; t . insertSys ( store , row ) ; } return t ; }
Retrieves a <code>Table</code> object describing the table types
available in this database. <p>

In general, the range of values that may be commonly encounted across
most DBMS implementations is: <p>

<UL>
<LI><FONT color='#FF00FF'>"TABLE"</FONT>
<LI><FONT color='#FF00FF'>"VIEW"</FONT>
<LI><FONT color='#FF00FF'>"SYSTEM TABLE"</FONT>
<LI><FONT color='#FF00FF'>"GLOBAL TEMPORARY"</FONT>
<LI><FONT color='#FF00FF'>"LOCAL TEMPORARY"</FONT>
<LI><FONT color='#FF00FF'>"ALIAS"</FONT>
<LI><FONT color='#FF00FF'>"SYNONYM"</FONT>
</UL> <p>

As of HSQLDB 1.7.2, the engine supports and thus this method reports
only a subset of the range above: <p>

<UL>
<LI><FONT color='#FF00FF'>"TABLE"</FONT>
(HSQLDB MEMORY, CACHED and TEXT tables)
<LI><FONT color='#FF00FF'>"VIEW"</FONT>  (Views)
<LI><FONT color='#FF00FF'>"SYSTEM TABLE"</FONT>
(The tables generated by this object)
<LI><FONT color='#FF00FF'>"GLOBAL TEMPORARY"</FONT>
(HSQLDB TEMP and TEMP TEXT tables)
</UL> <p>

@return a <code>Table</code> object describing the table types
available in this database