To delete/drop a database using query analyzer in Microsoft SQL server. We can use “DROP” statement.
Syntax:
DROP DATABASE Database_Name
How to verify:
You can check it in the list of databases with the following SQL Command.
SHOW DATABASES
OR
Dropped database will not be visible into database dropdown list in SQL Server
Important Notes:
Logged in user should have proper privileges/permission to drop database into SQL Server. If you are getting error message while dropping database, you can contact you SQL Server administrator/provider.
