EN
MS SQL Server - Drop table if exists
0 points
In this article, we would like to show you how to DROP TABLE IF EXISTS in MS SQL Server.
Quick solution:
xxxxxxxxxx1
DROP TABLE IF EXISTS [table_name];In this example, we will delete the users table.
Query:
xxxxxxxxxx1
DROP TABLE IF EXISTS [users];Output:
create_tables.sql file:
xxxxxxxxxx1
CREATE TABLE [users] (2
[id] INT IDENTITY(1,1),3
[name] VARCHAR(50) NOT NULL,4
[surname] VARCHAR(50) NOT NULL,5
[department_id] INT,6
[salary] DECIMAL(15,2) NOT NULL,7
PRIMARY KEY ([id])8
);