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/
