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:
Simple View
When view
are created with the help of single table it is called simple view
Complex View
Whereas when view are created
with more than 2 tables are called as complex views
No comments:
Post a Comment