What is Views? Explain its various type in detail.
Answers
Answered by
2
Answer:
Views are used to restrict data access. A View contains no data of its own but its like window through which data from tables can be viewed or changed. The table on which a View is based are called BASE Tables.
There are 2 types of Views in SQL: Simple View and Complex View. Simple views can only contain a single base table. Complex views can be constructed on more than one base table. In particular, complex views can contain: join conditions, a group by clause, a order by clause.
Similar questions