Thread: Number of Records in a Table

Help,

How can you determine how many records exist in a table with out doing a
SELECT statement and then counting the records that are read?

Thanks

On Fri, 9 Mar 2001, Charles Welch wrote:

->How can you determine how many records exist in a table with out doing a
->SELECT statement and then counting the records that are read?

I assume you mean counting by hand...

SELECT COUNT( -primarykey- ) FROM table;

obviously put your pirmary key and table name where they belong.

-- Dave