CREATE TABLE IF NOT EXISTS works on mysql but fails with SQL Server 2008 R2. What is the equivalent syntax?

10

1 Answer

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.

7