MariaDB DROP VIEW Keyword
The MariaDB DROP VIEW statement is used to delete a MariaDB VIEW. A MariaDB VIEW is a virtual table created based on the MariaDB statement. A view contains rows and columns just like a normal table. All MariaDB functions, WHERE, HAVING and JOINs statements can be used to create a MariaDB VIEW. Finally, to delete a MariaDB VIEW, DROP VIEW keyword is used.
Syntax
The syntax for using DELETE VIEW statement in MariaDB is given below:
DROP VIEW [IF EXISTS] view_name;
The IF EXISTS is an optional parameter that conditionally drops view only if it exists on the database. If a view is deleted which does not exist, it will raise an error.
Example:
Consider a database table called Employee with the following records:
EmpID | Name | City | Age | Salary |
---|---|---|---|---|
1 | John | London | 25 | 3000 |
2 | Marry | New York | 24 | 2750 |
3 | Jo | Paris | 27 | 2800 |
4 | Kim | Amsterdam | 30 | 3100 |
5 | Ramesh | New Delhi | 28 | 3000 |
6 | Huang | Beijing | 28 | 2800 |
The below mentioned MariaDB statement is used to create a view on Employee table which contains all records of employee whose salary is greater than 2800.
CREATE VIEW Employee_Salary_GT_2800 AS SELECT * FROM Employee WHERE Salary > 2800;
After creating the VIEW, it can be used as mentioned below:
SELECT * FROM Employee_Salary_GT_2800;
This will produce the result as shown below:
EmpID | Name | City | Age | Salary |
---|---|---|---|---|
1 | John | London | 25 | 3000 |
4 | Kim | Amsterdam | 30 | 3100 |
5 | Ramesh | New Delhi | 28 | 3000 |
The DROP VIEW keyword is used to delete a view.
DROP VIEW Employee_Salary_GT_2800;
❮ MariaDB Keywords