Views in SQL || Create, Modify and Drop | SQL in Tamil|| SQL Tutorial for Beginners in தமிழ்||
A view is nothing more than a SQL statement that is stored in the database with an associated name. A view is actually a composition of a table in the form of a predefined SQL query.
A view can contain all rows of a table or select rows from a table. A view can be created from one or many tables which depends on the written SQL query to create a view.
CREATE VIEW view_name AS
SELECT column1, column2.....
FROM table_name
WHERE [condition];