MS SQL Server - how to check the valid status of view

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

how to check the valid status of view

harvinder

2006-01-30, 8:23 pm

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

Thanks
--Harvinder

Edgardo Valdez, MCSD, MCDBA

2006-01-30, 8:23 pm

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 valid
> or is the status of the view is stored in any system table?
>
> Thanks
> --Harvinder
>
>
>

Sponsored Links