SQL Create- View

nIn SQL, a view is a virtual table where it contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

Syntax:

CREATE VIEW view_name AS SELECT column_name(s)
FROM table_name WHERE condition

Query:

üCREATE VIEW [Current order List] AS SELECT PROname, unit, unitprice FROM ORDtbl WHERE Discontinued=No

üDROP VIEW Current product List