Mega Code Archive

 

Categories / MSSQL / System

 

Another way to test for the existence of a table

4> 5> create table Billings ( 6>     BankerID           INTEGER, 7>     BillingNumber      INTEGER, 8>     BillingDate        datetime, 9>     BillingTotal       INTEGER, 10>     TermsID            INTEGER, 11>     BillingDueDate     datetime , 12>     PaymentTotal       INTEGER, 13>     CreditTotal        INTEGER 14> 15> ); 16> GO 1> 2> 3> IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES 4>         WHERE (TABLE_NAME = 'Billing' AND 5>         TABLE_TYPE = 'BASE TABLE')) 6>     DROP TABLE Billing 7> GO 1> 2> drop table Billings; 3> GO