Getting Information About a View
You can gain information about the definition of a view if it is not encrypted. You may need to see the definition of the view to understand how its data is derived from the source tables or to see the data defined by the view.
Views are queried the same way that ordinary tables are queried. However, any table hints used when querying the view are ignored. For more information about table hints, see SELECT (Transact-SQL).
If you change the name of an object referenced by a view, you must modify the view so that its text reflects the new name. Therefore, before renaming an object, display the dependencies of the object first to determine if any views are affected by the proposed change.
To get information about a view
To view the data defined by a view
To display the dependencies of a view