EN
MS SQL Server - Drop view if exists
0 points
In this article, we would like to show you how to DROP VIEW IF EXISTS
in MS SQL Server.
Quick solution:
xxxxxxxxxx
1
DROP VIEW IF EXISTS [view_name];
To show how the DROP VIEW IF EXISTS
statement works, we will use the following table:

Note:
At the end of this article you can find database preparation SQL queries.
In this example, we will delete the Spain Users
view which we created in this article.
Query:
xxxxxxxxxx
1
DROP VIEW IF EXISTS [Spain Users];
Output:


create_tables.sql
file:
xxxxxxxxxx
1
CREATE TABLE [users] (
2
[id] INT IDENTITY(1,1),
3
[name] VARCHAR(100) NOT NULL,
4
[email] VARCHAR(100) NOT NULL,
5
[country] VARCHAR(15) NOT NULL,
6
PRIMARY KEY ([id])
7
);
insert_data.sql
file:
xxxxxxxxxx
1
INSERT INTO [users]
2
([name], [email], [country])
3
VALUES
4
('Tom', 'tom01@email.com', 'Poland'),
5
('Chris','chris123@email.com', 'Spain'),
6
('Jack','jack32@email.com', 'Spain'),
7
('Kim','kim103@email.com', 'Vietnam'),
8
('Marco','marco942@email.com', 'Italy'),
9
('Kate','kate227@email.com', 'Spain'),
10
('Nam','nam393@email.com', 'Vietnam');