Database loop example

Import-Module sqlps -DisableNameChecking

$dbs = Invoke-SqlCmd -ServerInstance 'localhost' -Query 'select name from sys.databases where database_id > 4'

foreach($db in $dbs){
    Invoke-Sqlcmd -ServerInstance 'localhost' -Database $db.name -Query 'select count(1) from sys.objects'
}