I am starting a documentation package for our database, listing all
tables and columns with a description of what they do.
(since I am 71, I assume someday Sami Aaron might have to deal with it)
We are running 7.5
I was able to project a table list from the SYS_TABLES table, but
cannot find a method of projecting a table listing all column names.
I assumed that SYS_COLUMNS would provide that information, but it does not.
I can do it by writing 'list columns' into a text file, & then
manipulating that into a table, but there must be an easier way.
Thanks
Dick Fey
Carpet Broker Inc
Lenexa KS