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


Reply via email to