CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]

sql sql-server sql-server-2008-r2

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.

CodeHunter