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 <[EMAIL PROTECTED]> wrote:
select TABLENAME from SYS.SYSTABLES where TABLETYPE='T'
Doesn't this work for you ?
Jitesh
----- Original Message ----- From: "Nik" <[EMAIL PROTECTED]>
To: <[email protected]>
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/
