Creating views in T-SQL or in the view designer
Part one of a five-part series of blogs

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.

  1. Views in SQL Server (this blog)
  2. The View Designer
  3. Scripting views using SQL
  4. The Pros of using Views in SQL Server
  5. The Disadvantages of Views

This is part of our full tutorial online on SQL.Have a look also at our SQL training courses for businesses.

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 views in a database

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.

This blog has 0 threads Add post