Kevin Mc

My brain has gone dead - I'm trying to find the table that holds column information (ie something like user_tables).

Just trying to create a script looking at every column in a particular table.

Only ones I can think of apart from user_tables is user_ind_columns (though that only shows the indexed columns)

Would ask on LazyDBA but I've unsubbed because of the volume - I'd get an answer on here quicker than I could subscribe!

Cheers.

boxst

Hello

Not "desc my_table"? That brings back the columns.

You can "select TABLE_NAME from user_tables" and then describe each table.

Steve.

popeye

Hello.

user_tab_columns.

Cheers.

Kevin Mc

user_tab_columns - that's the one! Cheers

T.J

Try getting hold of a trial copy of TOAD (QWEST). Life is so much simpler with this when you need table info etc