Query DB for tables with records

Question

Query DB for tables with records

Chris Legan

SSC Journeyman

Points: 88
More actions
September 15, 2005 at 2:57 pm

#165485

I need to query my DB for tables in the DB that have > 100 records in them and also egt a record count from each table that meets the above requirement.

Thanks,

Chris

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294064 More actions · Answer 1

Select O.Name, MAX(I.rowcnt) AS rowcnt from dbo.SysObjects O inner join dbo.SysIndexes I on O.id = I.id where I.indid = 100 order by O.name

Please note that this is an approximate row count. If you need the actual exact rowcount, you must select from each table one at the time.

Chris Legan SSC Journeyman Points: 88 More actions · Answer 2

That worked great! If I wanted to sort these records by a field called dataareaid, how would I do that?

does this require a compound select statement? because if i type in my first select statement for dataareaid, then it runs both queries but seperates them in the pane. So basically I have narrowed down the tables that have more then 100 records, but now I need to sort those records by dataareaid = 'crp'

Thanks

Ninja's_RGR'us SSC Guru Points: 294064 More actions · Answer 3

Can you show me your current statement and the expected results vs the current results?