Creating View Visually in SQL Server 2008
Posted in SQL | Views December 13, 2012
In this article, we will see how to create a view visually in SQL Server 2008.
In this article I will explain how to create sql view virtually. View in SQL is a virtual table and this table is created on the result set of SQL statement. View is similar to a normal table and also have rows and columns. View may be combination of some rows and columns of two or more than two tables.
Steps to create view visually
Open Object Explorer in SQL Server Management Studio and right-click on Views under the databases and select "New View".
The "Add table" window will be opened. Select table of which you want to create view. And click on "Add" button.
A window will appear as following:
The available tables have no relation among them. Now select columns to relate one table to another.
Now right click on the query window and select "Execute". And see output: