SQL Server/T-SQL Tutorial/Data Convert Functions/DROP DATABASE

Code that tests whether a database exists before it deletes it

   <source lang="sql">

4> 5> IF DB_ID("TestDB") IS NOT NULL 6> DROP DATABASE TestDB 7> GO 1> 2> CREATE DATABASE TestDB 3> GO 1> 2> create table Billings ( 3> BankerID INTEGER, 4> BillingNumber INTEGER, 5> BillingDate datetime, 6> BillingTotal INTEGER, 7> TermsID INTEGER, 8> BillingDueDate datetime , 9> PaymentTotal INTEGER, 10> CreditTotal INTEGER 11> 12> ); 13> GO 1> 2> 3> IF OBJECT_ID("Billing") IS NOT NULL 4> DROP TABLE Billing 5> GO 1> 2> DROP DATABASE TestDB; 3> GO</source>

The DROP Database Statement

   <source lang="sql">

DROP DATABASE Accounting</source>