select * from syscat.tables
     will yield the index to the table spaces

        select * from syscat.columns
     will yield the index to column names with the table spaces

     that should be all you need, well maybe
        select * from syscat.enumtypes

     later,
           Dwight


______________________________ Reply Separator _________________________________
Subject: SQL Querries
Author:  sfluegge (sfluegge AT VENATORGROUP DOT COM) at unix,mime
Date:    4/27/99 8:03 AM


Does anybody have a list of all of the table and variable names?  I would like
to put together some SQL querries but I can't find a list of tables anywhere!!

Thanks,

Scott