SELECT obj.name, ind.rows, ind.dpages
FROM
sysindexes ind,
sysobjects obj
WHERE
ind.indid in (0,1)
and ind.id = obj.id
and obj.type = "U"