Sapna Malik
What is view?
By Sapna Malik in Databases & DBA on May 18 2011
  • Keerthi Venkatesan
    Apr, 2016 20

    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.

    • 0
  • Keerthi Venkatesan
    Apr, 2016 20

    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.

    • 0
  • Sapna Malik
    May, 2011 18

    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.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS