Mega Code Archive

 

Categories / MSSQL Tutorial / Data Convert Functions

 

Code that tests whether a database exists before it deletes it

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