A view is a virtual table.
CREATE VIEW [Current Product List] AS SELECT ProductID, ProductName FROM Products WHERE Discontinued=No
SELECT * FROM [Current Product List]
You can delete a view with the DROP VIEW command.
DROP VIEW view_name