I am using SQL-Server 2000 and have created a view namely
VW_TEST for the table e.g. TBL_TEST and query in this view
is "SELECT * FROM TBL_TEST". Now i ve changed the table
design i.e. i ve added new column to table,and while i run
the view VW_TEST again the out put of the view is as it
was earlier, while it should be changed and should show
the data of the new column too.
Right now for the same purpose I ve to drop the view
and create new view for the same query.
Please suggest some solution, or some good alternatives
if possible. my E-mail ID is rupesh_mca@yahoo.com or
indianrups@hotmail.com .

Rupesh

hi Rupesh,

Refresh view using sp_refreshview system sp.
Ex:
sp_refreshview <view_name>

-- Vishal