Categories
28°C, New York
Home SQL Let’s DELETE View

Let’s DELETE View

Let’s Create Some Views

Conclusion

Now we are gonna delete the views which are called HighSalaryEmployees and TOP_EMPLOYEE.

DROP VIEW HighSalaryEmployees;
DROP VIEW TOP_EMPLOYEE;

Now for confirming again execute the query:

SELECT TABLE_SCHEMA, EMPLOYEES 
FROM 
INFORMATION_SCHEMA.VIEWS
WHERE TABLE_SCHEMA='GFG';

Output:

TABLE_SCHEMA

EMPLOYEES

GFG

GOOD_EMPLOYEE

Explanation: This query retrieves information about views from the INFORMATION_SCHEMA.VIEWS table for a specific TABLE_SCHEMA (‘GFG’). It selects the TABLE_SCHEMA and EMPLOYEES columns from the VIEWS table, filtering the results to only include views from the ‘GFG’ schema.

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.

Similar Reads

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....

Let’s Create Some Views

Let’s Create a view name called HighSalaryEmployees...

Let’s DELETE View

Now we are gonna delete the views which are called HighSalaryEmployees and TOP_EMPLOYEE....

Conclusion

Overall, SQL Views offer a flexible and efficient way to manage and query your data. The DROP VIEW command allows you to easily remove views that are no longer needed, helping you maintain a clean and organized database schema. By understanding how to use views and the DROP VIEW command, you can improve the performance and manageability of your SQL databases....

Tags:
#Databases #SQL

Let’s Create Some Views

Conclusion