Test-SQLTableExists.ps1

function Test-SQLTableExists
{ 
    param ($Instance,$Database,$TableName)
    $Return = $SQL = $dataTable = $null
    $sql = "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'$TableName'"
    $dataTable = Invoke-Sqlcmd2 -ServerInstance $Instance -Database $Database -Query $sql
    if ($dataTable) {$return = $true}
    else {$return = $false}
    $Return
}