Friday, 21 December 2012 13:51

how to Use View tables in Sql server

Written by 
Rate this item
(0 votes)

if we need some fields from different tables
temporarily in our software or application then

creating a table with those wanted fields
or writing the complex query for accessing those
fields is time consuming,tedious and needs much
more coding.

therefore instead of creating a table with those
wanted fields or writing complex queries,we may
create a view table taking the fields from
those tables which includes the fields of interest
within a very short time.It has many advantages.
following steps shows how to create a view -

1.open or expand the database folder in sql server

2.then right click on the view folder and click
new view.

3.from the add table dialog box select the tables
from which the fields needed and click add.after
that click close button.

4.u will see the table fields.select which fields
u need to create view table.then click save button
in sql server.

5.give a name of the view table.

6.done.you created a view table.use it as a table
with your required fields.

Read 1155 times
Super User

Email This email address is being protected from spambots. You need JavaScript enabled to view it.
Login to post comments