[Db-derby Wiki] Update of "ListTableNames" by StanleyBradbury

[Apache Wiki <wi...@apache.org>]

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:
http://wiki.apache.org/db-derby/ListTableNames

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
}}}