EN
MS SQL Server - CREATE TABLE IF NOT EXIST equivalent
0
points
In this article, we would like to show you how to create a table if not exists in MS SQL Server.
Quick solution:
IF OBJECT_ID(N'[dbo].[table_name]', N'U') IS NULL
BEGIN
CREATE TABLE [dbo].[table_name] (
[column1] DATA_TYPE,
[column2] DATA_TYPE,
[column3] DATA_TYPE,
...
);
END;
Note:
Go to the official documentation to see available
DATA_TYPES.
Practical example
In this example, we create users table with the following columns and types:
id- INT IDENTITY(1,1),name- VARCHAR,role- VARCHAR.
Query:
IF OBJECT_ID(N'[dbo].[users]', N'U') IS NULL
BEGIN
CREATE TABLE [dbo].[users] (
[id] INT IDENTITY(1,1),
[name] VARCHAR(100) NOT NULL,
[role] VARCHAR(15) NOT NULL,
PRIMARY KEY ([id])
);
END;
Database:
