SQL Server/T-SQL/Database/DROP DATABASE

A statement that deletes a database

   <source lang="sql">

DROP DATABASE New_AP

</source>
   
  

Drop a database if it exists

   <source lang="sql">

4> USE master 5> GO Changed database context to "master". 1> 2> --Create a database 3> IF EXISTS(SELECT name FROM sys.databases 4> WHERE name = "ProSSEAppsCh07") 5> DROP DATABASE ProSSEAppsCh07 6> GO 1> 2> CREATE DATABASE ProSSEAppsCh07 3> GO

</source>