Re: ** HELP ** How to get the number of columns of tables;

duffy_at_cais2.cais.com (MCC) wrote:

>I would like to count the numbers of columns for every tables in the
>database. Instead of using DESCRIBE to get the columns for each table and
>count them, is there any smarter way of doing this?

Select Table_Name, Count(*)
  from User_tab_columns
  group by Table_name;

'Keystroke'
KeystrkTX_at_AOL.COM Received on Mon May 20 1996 - 00:00:00 CEST