After creating tables in SQl server 2005,its time to create views.The Views are reprsentations of parts of the table generated by the datbase based on a usedefined query. These are used primarily to view only required data from a large table.
Expand the database in which the view has to be created and right click on the Views.Select the create new View option and you will be presented with the above screen with the list of tables that are present in the database.We select the emp_table and click on add and then close this window.
After the above window is closed the below window appears. It has four different parts. The top most part contains the list of columns in the emp_table which can be added to the view.The next part provides various options to customise the view. The columns to be included and the alias name that have to be given to those columns in the view, the table in which the column is present, the way the column has to be sorted in the view, the sort order to be followed in the
view, any filters to be used in the view and other options such as the use of aggregate functions etc.