I've been browsing the result of: select * from tables
And I've found that a lot of data seems to be available from multible tables, take for example the metadata for columns: SYSODBCCOLUMNS COLS ALL_TAB_COLUMNS COLUMNS I have the feeling that the tables are all just different ways fo presenting the information to be compatible with different ways of doing things, but it's a bloody mess and there is no documentation on most of it. Is there some documentation or some source you can point me at that will explain what the special (ie: non-user) tables/views/synonyms are used for? -- Regards Flemming Frandsen aka. Dion/Swamp http://dion.swamp.dk
