refresh view

Hello,
My problem is that I don't know how to refresh the view. Actually, what I
want to programaticaly do is something equivalant to presing the "run" butto
n
in the Enterprise manager.
A stored procedure that will do it, will also be good. But the only stored
procedure that I thought about is to drop the view and to create it again
(not a very elegant solution).
Do you know how I can solve this problem?
thanks!We could tell you, if you tell as the coding your using. "Refreshing" a view
means getting the data new, this differs in the languages.
HTH, Jens Suessmeyer.
"Liat" <Liat@.discussions.microsoft.com> schrieb im Newsbeitrag
news:83A7E9FC-9B15-4529-B49E-7EB2E27E4709@.microsoft.com...
> Hello,
> My problem is that I don't know how to refresh the view. Actually, what I
> want to programaticaly do is something equivalant to presing the "run"
> button
> in the Enterprise manager.
> A stored procedure that will do it, will also be good. But the only stored
> procedure that I thought about is to drop the view and to create it again
> (not a very elegant solution).
> Do you know how I can solve this problem?
> thanks!|||Liat
sp_refreshview stored procedure
"Liat" <Liat@.discussions.microsoft.com> wrote in message
news:83A7E9FC-9B15-4529-B49E-7EB2E27E4709@.microsoft.com...
> Hello,
> My problem is that I don't know how to refresh the view. Actually, what I
> want to programaticaly do is something equivalant to presing the "run"
button
> in the Enterprise manager.
> A stored procedure that will do it, will also be good. But the only stored
> procedure that I thought about is to drop the view and to create it again
> (not a very elegant solution).
> Do you know how I can solve this problem?
> thanks!|||I am using C++
"Jens Sü?meyer" wrote:

> We could tell you, if you tell as the coding your using. "Refreshing" a vi
ew
> means getting the data new, this differs in the languages.
> HTH, Jens Suessmeyer.
> "Liat" <Liat@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:83A7E9FC-9B15-4529-B49E-7EB2E27E4709@.microsoft.com...
>
>|||Hi
View doesnt store any data. Selecting rows from a view is as good as
executing the query that created it.
We go for views because, it improves the performance of a query.
thanks and regards
Chandra
"Liat" wrote:

> Hello,
> My problem is that I don't know how to refresh the view. Actually, what I
> want to programaticaly do is something equivalant to presing the "run" but
ton
> in the Enterprise manager.
> A stored procedure that will do it, will also be good. But the only stored
> procedure that I thought about is to drop the view and to create it again
> (not a very elegant solution).
> Do you know how I can solve this problem?
> thanks!|||> We go for views because, it improves the performance of a query.
Unless you are talking about indexed views, I disagree.sql