tesh <[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:
Sent: Friday, December 28, 2007 4:39 PM
Subject: Howto get existing t
select TABLENAME from SYS.SYSTABLES where TABLETYPE='T'
Doesn't this work for you ?
Jitesh
- Original Message -
From: "Nik" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 28, 2007 4:39 PM
Subject: Howto get existing table names
Hi, I apologize i
Try passing a NULL under the 'TABLE_NAME' parameter to the
DatabaseMeataData. That should return all table names.
-Original Message-
From: Nik [mailto:[EMAIL PROTECTED]
Sent: Friday, December 28, 2007 6:09 AM
To: derby-user@db.apache.org
Subject: Howto get existing table na
>From the class documentation of DatabaseMetaData (JDK 6):
"If a search pattern argument is set to null, that argument's
criterion will be dropped from the search."
Raymond
On Dec 28, 2007 9:44 AM, Mark Thornton <[EMAIL PROTECTED]> wrote:
> Raymond Kroeker wrote:
> > I've also found that passi
Raymond Kroeker wrote:
I've also found that passing null also includes all tables.
It might do, but as the documentation for DatabaseMetaData.getTables
doesn't define what happens for a null tableNamePattern argument, it
would be better not to rely on this. Odd though given that null is
expli
I've also found that passing null also includes all tables.
Raymond
On Dec 28, 2007 3:09 AM, Nik <[EMAIL PROTECTED]> wrote:
> 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
Nik wrote:
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.
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
