I had been using sp_msforeachdb for long to search any object (table, column, Procedure, etc) on a given SQL instance. I come across similar SP sp_msforeachtable which can be used to run against all tables.
sp_msforeachtable 'execute(''select "?", COUNT(*) from ?'')' GO sp_msforeachtable 'select "?"'