Skip to content

Instantly share code, notes, and snippets.

@jetstreamin

jetstreamin/delete-sql.ps1

Forked from develohpanda/delete-sql.ps1
Last active April 7, 2020 16:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jetstreamin/fc2d022dde1dfaa30d16a77534fbc464 to your computer and use it in GitHub Desktop.
Save jetstreamin/fc2d022dde1dfaa30d16a77534fbc464 to your computer and use it in GitHub Desktop.
Download ZIP
Drop SQL database from Powershell
Raw
delete-sql.ps1
function Delete-SqlDatabase($serverName, $databaseName) {
Import-Module SQLPS
$server = New-Object Microsoft.SqlServer.Management.Smo.Server($serverName)
$db = $server.databases[$databaseName]
if ($db) {
$server.KillAllprocesses($databaseName)
$db.Drop()
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment