Back

Explore Courses Blog Tutorials Interview Questions

What is View in SQL?

0 votes
2 views
in SQL by (9k points)
What is View in SQL?

1 Answer

0 votes
by (45.3k points)

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:

Related questions

0 votes
1 answer
What is the use of view in sql?
asked Oct 21, 2020 in SQL by dev_sk2311 (45k points)
0 votes
1 answer
What is the command used to define view in SQL?
asked Oct 20, 2020 in SQL by dev_sk2311 (45k points)
0 votes
1 answer
How do I view all tables in SQL?
asked Aug 16, 2020 in SQL by Sudhir_1997 (55.6k points)
0 votes
1 answer
How to update view in SQL?
asked May 7, 2020 in SQL by Praveen_1998 (119k points)
0 votes
1 answer
Can we pass parameters to a view in SQL?
asked Jul 22, 2019 in SQL by Tech4ever (20.3k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...