BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Views are queries that you can save and reuse; but you can also use them as a basis for further queries. They do have their foibles too, as this blog explores.
- Views in SQL Server (this blog)
- The View Designer
- Scripting views using SQL
- The Pros of using Views in SQL Server
- The Disadvantages of Views
Posted by Andy Brown on 17 December 2012
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Views in SQL Server
A view is simply an SQL query that you've saved and want to be able to run again in the future.
Some of the views in the Wise Owl Movies database.
This bit of our SQL training series shows how to create, amend and use views. I've divided it up into 5 bits:
|Part||What it covers|
|Designing views||Creating views in design view.|
|Scripting views||Writing SQL to create and alter views.|
|Pros of views||Why you should be using views.|
|Cons of views||Why you might not want to use views.|
Let's start with how to create or change a view in the view designer.
For users of Access: a view is almost exactly the same as an Access query, if this helps.