Re: recordcount without query

[Adam Cameron <adam_junk@xxxxxxxxxxx>]

> I'm not aware of a better way of doing it than that.

It's "amazing" what one can find it one only looks.

I googled "oracle number of rows in a table" and it took me about 15min of
experimentation to come up with this:

select num_rows
from user_tables
where table_name = '#nameOfTable#'

You didn't seem to mention which DB system you're using (always helpful
when asking questions, btw), but if not Oracle I'm sure you can apply
yourself in the same way I have to find your own answers.

-- 
Adam