Record count in database

[Mike Yocca]

I have a need to know how many records are in tables within a database.
While we are doing development in a test database, I am modifying tables
that have dependencies. If developers have not added records to one of
the dependencies, my job is much easier because I can simply drop the
table.

I am considering writing an sp_RecordCount that accepts a parameter for
the where name like(@tblParam). I'd like to know if someone has already
written a procedure that has this functionality or if there is some sort
of shareware area for these types of procedures........

[David Upham]

In article <4lvtd3$f...@taurus.bv.sgi.net>, myo...@sgi.net says...

sp_spaceused tablename returns the number of records in a table as well
as other information. You could look at the text of sp_spaceused and
modify it to create your own procedure.

--
David Upham
Nan Pao Information Systems, Inc.
Phone: 886-2-816-5511 ext. 35
Fax: 886-2-813-2111
E-Mail: np...@ms1.hinet.net

[Roger S. Layton]

On Sunday, April 28, 1996, Mike Yocca wrote...

> I have a need to know how many records are in tables within a database.

I use 'select count(*) from tablename.

Roger