CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
if not exists (select * from sysobjects where name='cars' and xtype='U')
create table cars (
Name varchar(64) not null
)
go
The above will create a table called cars if the table does not already exist.