An output of a query can be stored as a view. View acts like small table which meets our criterion. View is a precomplied 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.
Liked By
Write Answer
What is a SQL view?
Join MindStick Community
You have need login or register for voting of answers or question.
Pushpendra Singh
01-Nov-2010