What are Views in SQL?

In: Computer Databases

[Edit]

A database View is a query which shows a portion of data in the database. It can be thought of as a virtual table.

An example of a view would be one in which all attributes of an employee are returned as the result without salary details. Views are often used to provide "filtered" views of a database.

A view can also hide the complexity of getting the correct data when a query is sent.

First answer by Sqlguy. Last edit by Sqlguy. Contributor trust: 0 [recommend contributor]. Question popularity: 1 [recommend question]

Research your answer:

Can you answer other questions about databases and data management systems?

Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Databases > What are Views in SQL?

Our contributors said this page should be displayed for the questions below. (Where do these come from

)

If any of these are not a genuine rephrasing of the question, please help out and edit these alternates.

What is views in sql? What are views in SQL and what is its use?