[PHP] Re: List tables

2003-03-17 Thread Arnold Schommer 
Hi, Shaun,

Shaun wrote:
 
 Hi,
 
 i would like to list all of the tables and field names in my database
 
 e.g.
 
 table 1
   field 1
   field 2
   field 3
 table 2
   field 1
   field 2
   field 3
 table 3
   field 1
   field 2
   field 3
 etc
 
 is there a simple way to do this?
 
 thanks for your help

Usually any database has its data dictionary you may query via sql, but afaik
there is no real standard how the views are named etc.
What database are you takling about ?
For oracle e.g., you can start with something like 
select table_name, column_name from user_tab_columns
hth

-- 
Arnold Schommer

FS EDV Service  Beratung GmbH

An der Pönt 48
40885 Ratingen

fon: +49 2102 186 400
fax: +49 2102 186 499

mailto:[EMAIL PROTECTED]
http://www.fs-edv.de

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: List tables

2003-03-15 Thread Joel Colombo 
duplicate POST from php.db


Shaun [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 Hi,

 i would like to list all of the tables and field names in my database

 e.g.

 table 1
   field 1
   field 2
   field 3
 table 2
   field 1
   field 2
   field 3
 table 3
   field 1
   field 2
   field 3
 etc

 is there a simple way to do this?

 thanks for your help





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php