In this article, we would like to show you how to
DROP TABLE IF EXISTS in MS SQL Server.
DROP TABLE IF EXISTS [table_name];
In this example, we will delete the
DROP TABLE IF EXISTS [users];
CREATE TABLE [users] ( [id] INT IDENTITY(1,1), [name] VARCHAR(50) NOT NULL, [surname] VARCHAR(50) NOT NULL, [department_id] INT, [salary] DECIMAL(15,2) NOT NULL, PRIMARY KEY ([id]) );