Getting Information About Views

To display the text used to create a view, execute the sp_helptext system stored procedure with the view name as the parameter.

Note Views created with the ENCRYPTION option cannot be viewed with the sp_helptext system stored procedure.

To get a report of the tables or views on which a view depends, and of objects that depend on a view, execute the sp_depends system stored procedure.

You can rename a view with the sp_rename system stored procedure.

Permission

CREATE VIEW permission defaults to the database owner, who can transfer it to other users. The creator of a view must have SELECT permission for any object referenced in the view definition to SELECT from the view.