db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nik <nicholas.tr...@gmail.com>
Subject Re: Howto get existing table names
Date Mon, 31 Dec 2007 04:49:36 GMT
Actually what I've done is this:
String[] types = {"TABLE"};
         ResultSet resultSet = dbmd.getTables(null, null, "%", types);
I then cycle the result with a while loop and rs.next(). Thanks for  
everyone's responses.
On Mon, 31 Dec 2007 12:34:57 +0900, Jitesh <jiteshmehta@pramati.com> wrote:

> select TABLENAME from SYS.SYSTABLES where TABLETYPE='T'
>
> Doesn't this work for you ?
>
> Jitesh
>
> ----- Original Message ----- From: "Nik" <nicholas.tripp@gmail.com>
> To: <derby-user@db.apache.org>
> Sent: Friday, December 28, 2007 4:39 PM
> Subject: Howto get existing table names
>
>
>> Hi, I apologize if this is too simple a question.  I'm tring to make a  
>> statement to return all the tables in the database.  I haven't been  
>> able to find how to do this yet.  I was trying to use DataBaseMetaData,  
>> but the method seems to require the table names.  Thank you in advance.
>>
>> -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>



-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Mime
View raw message