Drop Method

Database.Drop Method ()


Drops the database.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public void Drop()

The Drop method removes the database from the instance of SQL Server. If the database cannot be dropped, (possibly because of open connections), you can use KillAllProcesses to close the connection(s) and drop the database.



$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database($srv, "Test_SMO_Database")
Write-Host $db.CreateDate
Return to top
© 2015 Microsoft