db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "ListTableNames" by StanleyBradbury
Date Fri, 23 Jun 2006 21:19:25 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by StanleyBradbury:

New page:
## Submitted June 23, 2006
== 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

View raw message