Delete MSDE/SQL Server Databases??

[jgoodman00]

How do you delete existing SQL server databases, because I am experimenting with the access upsizing wizard & upsizing different objects. Obviously each upsize is creating a new database & project file. How do I delete the databases I have created which I no longer want???

James Goodman
j.goodman00@btinternet.com

 

[magdyk]

you can use DROP DATABASE database_name [ ,...n ]
if u r using visual basic on the ado connection
the connection must be to the master database
cn.execute "use master"
cn.execute "DROP DATABASE database_name "