Re: Getting Row Counts for ALL Tables

#1

Thanks to both of you -- that's exactly what I needed.

"Breck Carter [TeamSybase]" <NOSPAM__bcarter (AT) risingroad (DOT) com> wrote in
message news:i2tssv0kpi8dtjg6610t3qcotsc03jbofo (AT) 4ax (DOT) com...

Quote:

If the database is quiet, then the following will give an accurate
report:

CHECKPOINT;
SELECT table_name,
count
FROM SYSTABLE;

On 3 Dec 2003 14:46:43 -0800, "Kevin" <kah (AT) asus (DOT) net> wrote:

Hello. I am using an ASA 8 database and would like to produce a report
showing each table and the number of rows for each. Does anyone know of
a
system procedure to accomplish this?

When using Sybase at my previous employer, I thought I used something
like
a sp_spaceused system stored procedure, or something like that. I see
that
ASA 8 has a SP named this, but it looks like a stub that doesn't really
do
anything.

I haven't been using ASA 8 for that long, so it could well be something
fairly obvious that I'm missing. In any case, any advice on this matter
would be appreciated.

Thanks,

Kevin

P.S. I should point out that this report does not have to have *only*
these
two columns (table name and rowcount). As long as it has *at least*
those
two, it will serve my purpose.

--
bcarter (AT) risingroad (DOT) com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Getting Row Counts for ALL Tables

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Re: Getting Row Counts for ALL Tables - 12-17-2003 , 10:48 AM