Differences between revisions 4 and 5
Revision 4 as of 2006-09-21 16:54:10
Size: 722
Editor: cpe-24-25-218-26
Comment: Added actual doc link for new 'show tables|views' and 'describe' commands.
Revision 5 as of 2009-09-20 22:11:57
Size: 728
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 14: Line 14:
The upcoming [http://wiki.apache.org/db-derby/TenTwoSnapshot 10.2 release] adds
[http://db.apache.org/derby/docs/dev/tools/rtoolsijcomrefshow.html show tables | views] and
[http://db.apache.org/derby/docs/dev/tools/rtoolsijcomrefdescribe.html describe] commands to {{{ij}}}.
The upcoming [[http://wiki.apache.org/db-derby/TenTwoSnapshot|10.2 release]] adds
[[http://db.apache.org/derby/docs/dev/tools/rtoolsijcomrefshow.html|show tables | views]] and
[[http://db.apache.org/derby/docs/dev/tools/rtoolsijcomrefdescribe.html|describe]] commands to {{{ij}}}.

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)