The View in SQL is a virtual table that is mainly based on the result of a SQL statement. It consists of rows and columns which are similar to that of a real table. The data fields in a view are those from one or many real tables present in the database. They are used for security measures in databases as they restrict users from seeing and manipulating certain sets of rows and columns.
Types of View: Simple View and Complex View.
Single Views are those that can contain only a single base table. However, Complex Views are those that can be constructed on one or more base tables.
To learn in-depth about SQL and view, you should read the SQL Tutorial.
You must also watch this comprehensive video tutorial on SQL:
Back