db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jitesh" <jiteshme...@pramati.com>
Subject Re: Howto get existing table names
Date Mon, 31 Dec 2007 03:34:57 GMT

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/ 


Mime
View raw message