Home Forums SQL Server 7,2000 Administration Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname
ksiozios
SSC Enthusiast
Points: 149
More actions
July 7, 2015 at 9:50 am
#1810751
This may have been answered already but this worked for me:
sp_MSforeachtable "select '?', count(1) from ?"