Loading
What is view?
3 Answers
A view can contain all rows of a table or select rows from a table. A view can be created from one or many tables.
Keerthi VenkatesanPosted Apr 20, 2016, 5:38 AM
A view can contain all rows of a table or select rows from a table. A view can be created from one or many tables.
Keerthi VenkatesanPosted Apr 20, 2016, 5:38 AM
A view takes the output of a query and makes it appear like a virtual table. You can use a view in most places where a table can be used. All operations performed on a view will affect data in the base table and so are subject to the integrity constraints and triggers of the base table.
A View can be used to simplify SQL statements for the user or to isolate an application from any future change to the base table definition. A View can also be used to improve security by restricting access to a predetermined set of rows or columns.
Sapna MalikPosted May 18, 2011, 12:47 AM