SQL-Statement

Detlef · *nix forums beginner Joined: 11 Mar 2005 Posts: 5

Hi Sara,

it works fine. Thanks

regards,
Detlef

"DBAGAL" <saradba@hotmail.com> wrote in message news:<1112716765.434455.58660@l41g2000cwc.googlegroups.com>...

DBAGAL · *nix forums beginner Joined: 31 May 2005 Posts: 39

Heya Detlef,

Try this:

select object_name(id), rowcnt
from systabstats
where indid in (0,1)
order by rowcnt desc

You want to ensure you are running "update statistics" regularly and
even might want to run "sp_flushstats" prior to running the above
query.

Anyone with a better solution?

Cheers,

Sara ..

Detlef wrote:

Detlef · *nix forums beginner Joined: 11 Mar 2005 Posts: 5

Hi all,

I have a question about a Siebel Sybasedatabase.
I want to know which of the tables a user had created has the most
rows of all tables. The SQL-Statement have to spend all the tablenames
and number of rows.

could anyone please help me?

many thanks for all.

regards,
deha

Google