InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is A Sql View? |
|
Answer» An output of a query can be stored as a view. View acts LIKE small table which meets our criterion. View is a pre-complied SQL query which is used to select data from one or more TABLES. A view is like a table but it doesn't physically take any space. View is a good way to present data in a PARTICULAR format if you use that query quite often. View can ALSO be used to restrict users from accessing the tables directly. An output of a query can be stored as a view. View acts like small table which meets our criterion. View is a pre-complied SQL query which is used to select data from one or more tables. A view is like a table but it doesn't physically take any space. View is a good way to present data in a particular format if you use that query quite often. View can also be used to restrict users from accessing the tables directly. |
|