Re: ** Help ** How to find.....

Check sql reference manual, specifically the sections that talk about the data dictionary views, user_indexes, user_tables, user_constraints, user_tab_columns. The system maintains a large variety of information about the objects it stores. For instance you can issue the following command from the sqlplus prompt to get needed information. describe user_tables then you coule use a select statement based on the columns of data you want. John. Received on Tue May 21 1996 - 00:00:00 CEST