SQL DELETE Views
- When it comes to defining views then Views in SQL are referred to as virtual tables that are created whenever we use the SELECT command.
- The DELETE VIEW command does not exist. To remove a view from a database, we use the DROP VIEW command. This command deletes the view definition from the database. But it does not delete any underlying tables or data.
- Views are commonly used to simplify complex queries, provide an additional layer of security and present data in a more understandable format.
Syntax:
DROP VIEW view_name;
Let’s get into the DROP VIEW command with the examples:
Let’s Set Up an Environment
To understand SQL – DELETE View we need a table on which we will perform various operations and queries. Here we will consider a table called EMPLOYEES which contains data as shown below:
CREATE TABLE EMPLOYEES (
ID INT PRIMARY KEY,
HighSalaryEmployees VARCHAR(255),
GOOD_EMPLOYEE VARCHAR(255),
TOP_EMPLOYEE VARCHAR(100)
);
INSERT INTO EMPLOYEES (ID, HighSalaryEmployees, GOOD_EMPLOYEE, TOP_EMPLOYEE) VALUES
(1, 'SACHIN', 'Harper Lee', 'JOHN'),
(2, 'PRAKHAR', 'George Orwell', 'BHUVAN'),
(3, 'BADAL', 'F. Scott Fitzgerald', 'SHYAM'),
(4, 'ABHISHEK', 'J.D. Salinger', 'MADAN'),
(5, 'KARTHIK', 'J.R.R. Tolkien', 'AKASH');
Output:
SQL – DELETE View
SQL Views provide a powerful way to simplify complex queries and present data in a more understandable format. However, there may be times when we need to remove a view from your database schema. In SQL, the DELETE VIEW command does not exist. So we use the DROP VIEW command to delete a view.
In this article, We will learn about the SQL DROP VIEW with detail understanding with the help of examples and so on.