Re: Accessing database statistics

On Thursday 30 May 2002 13:00, Tony Griffiths(RA) wrote:
> Hi,
> I need to write a query that returns the number of rows currently stored
> in a table. I presume that I issue a query against the system tables,
> but don't know which one(s) to do this against. So a couple of questions:
>
> 1) With specific reference to my problem, how do I do this?

select count(*) from mytable;

> 2) More generally, is there any where that gives detailed descriptions
> of the system tables?

I always take the view that they are for use by the system, and not for me.
I haven't needed system tables yet.

JohnT