select Statement Usage with create view

The select statement in the create view statement defines the view. You must have permission to select from any objects referenced in the select statement of a view you are creating.

You can create a view using more than one table and other views by using a select statement of any complexity.

On the select statements in a view definition, you cannot:

After you create a view, the source text describing the view is stored in the text column of the syscomments system table.

Note: Do not remove this information from syscomments. Instead, encrypt the text in syscomments with sp_hidetext. See the Reference Manual: Procedures.
Related concepts
Compiled Objects