Home > DeveloperSection > Interviews > What is a SQL view?

Posted on    October-25-2010 12:00 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  875  View(s)
Rate this:

Pushpendra Singh

Total Post:241

Points:1205
Posted on    November-01-2010 12:00 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick