Get-TableSet.ps1

# Show the content of a set of tables on a given database

function Get-TableSet($database, $tableSet) {
    $tableSet | ForEach-Object {
        $table = $_
        $query = "select '$table' as [Table-$table], * from [$database].[dbo].[$table] "
        Write-Host "Running [$query]."
        Invoke-Sqlcmd -ServerInstance localhost -U sa -P TheDemo -Query $query -Verbose |
            Out-GridView -Title "$database.$table "
    }
}
 
$database = "aa_somedb"
$tableset = "things","things2"
 
Get-TableSet $database $tableset