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

Reply via email to