A view is a list of columns or a series of records retrieved from one or more existing tables, or as a combination of one or more views and one or more tables. Based on this, before creating a view, you must first decide where its columns and records would come from. Obviously the easiest view is one whose columns and records come from one table.
Syntax for creating View
CREATE VIEW ViewName
Opening or executing View
To open or execute View we use same statement as we use to use for viewing Table records.