Friday, February 24, 2012

How to delete a sqlexpress database from the visual 2005

Hello,

I created a database in my local sqlexpress server, using the 'Create New SQL server database ..." option in the Server Explorer of VS 2005.

How can i delete this database now using VS 2005 ?

it seems that the 'Delete' option, only remove the link in the 'Data Conncetions ' folder.

Thanks and Regards

Denis

To delete a database go to the command line and type the following:

C:\>sqlcmd -S <server_name>\<instance_name>
1> drop database <db_name>
2> go
1>

e.g.

C:\>sqlcmd -S dtjones\sqlexpress
1> drop database deleteme2
2> go
1>

Cheers,
Dan

No comments:

Post a Comment