Question

Write a table for drop view command? ​

Answer 1

Here is a drop view command:

$\textbf{ Syntax }$

Create or Replace View- view_name AS

Select - column1, column2, ...

From- table_name

Where- condition;

Drop View- view_name;

$\textbf{ Example }$

Create View [Products Above Average Price] AS

Select ProductName, Price

From Products

Where Price > (SELECT AVG(Price) FROM Products);

Create or Replace View- [America Customers] AS

Select- CustomerName, ContactName, City

From- Customers

Where- Country = "America";

Drop View- [America Customers];