Views in Detail :
Few advantages of views:
- User has access to only those columns which are
selected in view query
- For Security purpose
user can only have access of listed columns in view. He can not access other
columns in database.
- View are basically
virtual tables, but they can accessed like simple table in sql.They does not
exist physically in database.
- We can create a view by writing a query on one or more tables.
Types of Views:
When view are created with the help of single table it is called simple view
Whereas when view are created with more than 2 tables are called as complex views