do some dynamic script generation by joining the relevant system tables.
Here is an example of this that I just now did for a work requirement:

select 'select ''' + s.name + '.' + o.name + ''' as ''tblname'', count(*)
from [' + s.name + '].[' + o.name + ']

go'

from sys.objects o inner join sys.schemas s on o.schema_id = s.schema_id

where type = 'u'

order by s.name, o.name

grab the output and paste it and execute:

select 'audit.BookedLoanApplications' as 'tblname', count(*) from
[audit].[BookedLoanApplications]

go

select 'audit.DealerApplications' as 'tblname', count(*) from
[audit].[DealerApplications]

go

...