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