Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

generic select all row counts in all tables

112 views
Skip to first unread message

Ana

unread,
Mar 24, 2011, 10:00:42 PM3/24/11
to
Hello
does anyone know of any script that can select all tables and rows
counts? this is for sybase 15.5 on solaris 10
many thanks

JaRamJEON

unread,
Apr 21, 2011, 3:29:19 AM4/21/11
to

check systabstats system table which has rowcnt column.
you might need to join using id column with sysobjects to get a table
name.

0 new messages