db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson" <...@bristowhill.com>
Subject Re: how to select all table names of some database in derby?
Date Sat, 23 Jun 2007 18:11:45 GMT

On Sun, 24 Jun 2007 01:20:24 +0800, "amadis" <perlive@gmail.com> said:
> Hi, derby-user 
>    
>    i created a table in derby, but i forgot the name of the table, is
>    there any sql that can show all the names out?

This wiki page has a sql query that might help:
   http://wiki.apache.org/db-derby/ListTableNames

It also mentions the ij 'show tables' command that was introduced with
10.2.
 
-jean

p.s. That wiki page is linked from this general hints&tips page:
http://wiki.apache.org/db-derby/HintsAndTips

Mime
View raw message