CREATE TABLE IF NOT EXISTS equivalent in SQL Server
SqlSql ServerSql Server-2008-R2Sql Problem Overview
CREATE TABLE IF NOT EXISTS
works on mysql but fails with SQL Server 2008 R2.
What is the equivalent syntax?
Sql Solutions
Solution 1 - Sql
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.