Re: List tables

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:aschommer@fs-edv.de http://www.fs-edv.de