It may not be the best way and you may be able to wrap an sp_msforeachtable with the sp_msforeachdb procedure but here is one way to iterate over each database...
I have not read all of the responses so perhaps someone else has pointed this out already but the title references "with no Indexes". However you referenced an Indexed View...
DBA is different from SQL Developer and I think being a developer, industrial experience is very important. I used to work with people coming out of college without...