Thursday, December 13, 2012

SQL-Views

What is view? 

A view is a "virtual table" in the database whose contents are defined by a query. To the database user, the view appears just like a real table, with a set of named columns and rows of data. But unlike a real table, a view does not exist in the database as a stored set of data values. Instead, the rows and columns of data visible through the view are the query results produced by the query that defines the view. SQL creates the illusion of the view by giving the view a name like a table name and storing the definition of the view in the database.

To read further click on the link below:
http://www.mediafire.com/view/?m2wyhtg7tkg90n8

0 comments:

Post a Comment

  • More Text

  • Unordered List

  • Pages