List of Sequences/Tables

[fpgiv]

Hi, is there a query I can use that will get the table/sequence names out of a table? And, if I do that, is there another query that would get the fieldnames out of a table?
Thanks!
~Phil

 

[lewisp]

Look at the system tables ALL_TABLES, ALL_TAB_COLUMNS and ALL_SEQUENCES.

 

[fpgiv]

How would you use it? For example, would select All_Tables from database_name do it?

 

[lewisp]

ALL_TABLES is itself a table.......