you can do it.

select a.name,b.rowcnt

from sysobjects as a inner join sysindexes as b

on a.id=b.id

and a.xtype='u'

and b.indid in (0,1)