Views
A view is a logical representation of another table or combination of tables A view is simply the representation of a sql statement that is stored in memory so that it can easily be re-used. With some restrictions, rows can be inserted into, updated in, or deleted from a base table using a view. Advantages of views · Views restrict accesses to the data because the view can display selected columns from the table. · Views can be used to make simple queries to retrieve the results of complicated queries for ex, views can be used to query information from multiple table without the user knowing how to write join statement. · Views provide groups of users access to data according to their particular criteria. Two types of views: 1. Simple view 2. ...