Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname

Question

Viewing post 31 (of 30 total)

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

Boyd Nelson-211801 SSC Journeyman Points: 80 More actions · Answer 1

This worked for me:

use <dbname>

go

exec sp_msforeachtable 'SELECT COUNT(*) FROM ?;'