Sams Teach Yourself SQL in 21 Days, Fourth Edition

CREATE VIEW

						CREATE VIEW <view_name> [(column1, column2...)] AS
SELECT <table_name column_names>
FROM <table_name>

A view is often described as a virtual table. Views are created by using the CREATE VIEW statement. After a view is created, it can be queried and data within the view can be modified.