How to create a View using SQL Server Management Studio 2005.

When we dealing with database it is very important to know about the Views of Database it will be help to create suitable SQL Statement and after createing that Views we can esily use them to do some task on our .net C# or VB application. Simply following below step you can create SQL Views.

1st step:

As a 1st step you must decide what is the database which you are going to create SQL Views. After that you can find number of option avalible with that selected data base. in here you must select View from that. Figure 1 show that Selecting View. By write clicking on that View and selecting New View you can create new view to you data base.



















Figure 1 shows that how to create SQL View

2nd step:

After doing 1st step it asks what are the data base table to use to create the SQL Views. In here according to your requirement you can provide suitable data base table for your SQL Views. Figure 2 shows that how to add data base tables to SQL View.















Figure 2

3rd step:

After that I looks like Figure 3. In here you can do what ever SQL Statements with the Data base table which added to the SQL View. And after by providing suitable name for SQL View can create SQL View.

Figure 3

By following above three steps esaly can create SQL Views.

Your Comments are highly appreciated; it will be improving my knowledge also.