y, January 24, 2001 11:23 AM
Subject: RE: [PHP-DB] Viewing the DB
>This was taken from one of the doc's on IBM's site:
>
>SYSTABLES contains a row for every table and view in the SQL collection. It
>tells you if the object is a table or view, the object name, the owner of
letcher [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 3:48 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Viewing the DB
I'm using IBM DB2. No Oracle, No mySQL.
Scott
""Scott Fletcher"" <[EMAIL PROTECTED]> wrote in message
94mt56$skf$[EMAIL P
EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 5:49 PM
Subject: RE: [PHP-DB] Viewing the DB
show tables;
Is that what you need? You want to list all tables of a certain database
right? Make sure to select the database using
use databasename;
before attempting to do this.
Best r
I'm using IBM DB2. No Oracle, No mySQL.
Scott
""Scott Fletcher"" <[EMAIL PROTECTED]> wrote in message
94mt56$skf$[EMAIL PROTECTED]">news:94mt56$skf$[EMAIL PROTECTED]...
> Does anyone know what is the sql command that would allow me to view all
of
> the tables in the database?
>
> Scott
>
>
>
> -
TECTED]]
> Sent: Wednesday, January 24, 2001 1:40 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Viewing the DB
>
>
> Does anyone know what is the sql command that would allow me
> to view all of
> the tables in the database?
>
> Scott
>
>
>
> --
> P
Scott Fletcher wrote:
> Does anyone know what is the sql command that would allow me to view all of
> the tables in the database?
In MySQL:
mysql> show tables;
+-+
| Tables in mysql |
+-+
| columns_priv|
| db |
| f
treff: [PHP-DB] Viewing the DB
Does anyone know what is the sql command that would allow me to view all of
the tables in the database?
Scott
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contac
Does anyone know what is the sql command that would allow me to view all of
the tables in the database?
Scott
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-m
