EN
MySQL - Drop view if exists
0 points
In this article, we would like to show you how to DROP VIEW IF EXISTS in MySQL.
Quick solution:
xxxxxxxxxx1
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:
xxxxxxxxxx1
DROP VIEW IF EXISTS `Spain Users`;Output:
If you try to drop a view that already exists with DROP VIEW query you will get an error:
But if you try to DROP VIEW IF EXISTS you will get a warning instead:
create_tables.sql file:
xxxxxxxxxx1
CREATE TABLE `users` (2
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,3
`name` VARCHAR(100) NOT NULL,4
`email` VARCHAR(100) NOT NULL,5
`country` VARCHAR(15) NOT NULL,6
PRIMARY KEY (`id`)7
)8
ENGINE=InnoDB;insert_data.sql file:
xxxxxxxxxx1
INSERT INTO `users`2
(`name`, `email`, `country`)3
VALUES4
('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');