$serverInstance $="$SRV$19-$PRIMARY$\backslash$SQLEXPRESS$"$

$databaseName $=$ "ClientDB"

$tableName $=$ "Client$\_$A$\_$contacts"

$csvPath $="$$PSScriptRoot$\backslash$NewClientData$.$csv$"$

try $\{$

$dbExistsQuery $="$if exists$($SELECT $*$ FROM sys$.$databases WHERE name$=\text{'}$$databaseName'$)$ SELECT $1$ ELSE SELECT $0"$

$dbExists $=$ Invoke$-$Sqlcmd $-$Serverinstance $serverInstance $-$Query $dbExistsQuery

if $($$dbExists $-$eq $1)\{$

Write$-$Host "Database $\text{'}$$databaseName' exist, removing it$..."$

$deletedatabase $=$ "DROP DATABASE $[$$databaseName$]"$

Invoke$-$Sqlcmd $-$ServerInstance $serverInstance $-$Query $deletedatabase

Write$-$Host $=$ "DATABASE $\text{'}$$databaseName' HAS BEEN DELETED!"

$\}$ else $\{$

Write$-$Host "DATABASE $\text{'}$$databaseName' does not exist"$\}$

$\}$

Catch

$\{$

Write$-$Host $"$An Error Has Occured Finding database"

$\}$

Im having trouble with my $"$if$"$ statement. When those database already exists the if statement won't delete the database properly.