December 17, 2012

SQL Views

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