A view is created with the CREATE VIEW statement.
CREATE VIEW view_name AS
SELECT column1, column2,
FROM table_name
WHERE condition;
In SQL, a view is a virtual table based on the result-set of an SQL statement. A view 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.
Tables in SQL are database objects that contain data itself in a structured manner, while views in SQL are database objects that represent saved SELECT queries in “virtual” tables.
A view is a virtual table in SQL that is based on the result set of a SQL operation. A view, like a true table, has rows and columns. A view’s fields are taken from one or more real tables in the database.
