Listing the User Tables in a Database

The following query will return the fully qualified table name of all user tables existing in a Derby database in the format <schema-name>.<table-name>. 

 select s.schemaname || '.' || t.tablename 
     from sys.systables t, sys.sysschemas s 
     where t.schemaid = s.schemaid
          and t.tabletype = 'T'
     order by s.schemaname, t.tablename

The upcoming 10.2 release adds show tables and describe commands to ij.

ListTableNames (last edited 2009-09-20 22:11:57 by localhost)