A SQL view functions as a table but is dynamic in nature. SQL views contain rows and columns just like a table. Views are created from one or more tables that belong to their respective databases.
CREATE VIEW viewName AS|
SELECT columnName1, columnName2,
CREATE VIEW newEmployees AS|
SELECT employeeID, employeeName, hireDate
WHERE hireDate > '01/01/2011'
The CREATE VIEW Statement used in this example created a view with three columns from the source table called Employees. You can now use
standard SQL Queries to retrieve data from this view.
Recommended Books & Training Resources