im using a mySql database and trying to get the table names via the
DatabaseMetaData method of getTables however, i think im getting tripped up
on the parameters.  all im looking for is a record set that contains the
tables in the database.
----- Original Message -----
From: "Alistair Whittle" <alistair.whittle@l...>
To: "Pro_JavaServer_Pages" <pro_jsp@p...>
Sent: Monday, February 05, 2001 9:09 AM
Subject: [pro_jsp] RE: java.sql question


> In Sybase the command:
>
> select * from sysobjects where type = "U"
>
> will do the job.
>
> -----Original Message-----
> From: surat.jewpojaroen@a... [mailto:surat.jewpojaroen@a...]
> Sent: 05 February 2001 02:05
> To: Pro_JavaServer_Pages
> Subject: [pro_jsp] RE: java.sql question
>
>
> In oracle use command like this "select * from tab;"
> It will be show all of table in the database that you want.
>
> -----Original Message-----
> From: Geert Van Damme [mailto:geert.vandamme@D...]
> Sent: Sunday, February 04, 2001 3:05 AM
> To: Pro_JavaServer_Pages
> Subject: [pro_jsp] RE: java.sql question
>
>
> NO IT DOESN'T !
>
> Use DatabaseMetaData
>
> Geert Van Damme
>
> > -----Original Message-----
> > From: Gregory_Griffiths@c...
> > [mailto:Gregory_Griffiths@c...]
> > Sent: zaterdag 3 februari 2001 18:45
> > To: Pro_JavaServer_Pages
> > Subject: [pro_jsp] RE: java.sql question
> >
> >
> > depends on your database, for example
> >
> > select table_name form all_tables
> >
> > works in Oracle
> >
> > > -----Original Message-----
> > > From: mattslists@o...
> > > [mailto:mattslists@o...]
> > > Sent: 02 February 2001 14:34
> > > To: pro_jsp@p...
> > > Subject: [pro_jsp] java.sql question
> > >
> > >
> > > how can i get a list of all the tables in a database.
>
>