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:
xxxxxxxxxx
1
DROP TABLE IF EXISTS [table_name];
In this example, we will delete the users
table.
Query:
xxxxxxxxxx
1
DROP TABLE IF EXISTS [users];
Output:


create_tables.sql
file:
xxxxxxxxxx
1
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
);