0 votes
1 view
in SQL by (9k points)
What is View in SQL?

1 Answer

0 votes
by (45.1k 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
asked Oct 21, 2020 in SQL by dev_sk2311 (38.9k points)
0 votes
1 answer
asked Oct 20, 2020 in SQL by dev_sk2311 (38.9k points)
0 votes
1 answer
asked Aug 16, 2020 in SQL by Sudhir_1997 (55.4k points)
0 votes
1 answer
asked May 7, 2020 in SQL by Praveen_1998 (119k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...