how to check the valid status of view

Is there a system function that I can run to check if the view is still vali
d
or is the status of the view is stored in any system table?

Thanks
--Harvinder

you could use:

sp_refreshview

From Books Online

sp_refreshview

Refreshes the metadata for the specified view. Persistent metadata for a
view can become outdated because of changes to the underlying objects upon
which the view depends.


"harvinder" wrote:

> Is there a system function that I can run to check if the view is still va
lid
> or is the status of the view is stored in any system table?
>
> Thanks
> --Harvinder
>
>
>