Creating Views

Creating Views
---------------------------
A view can be created by using the CREATE VIEW statement.
================================================
Syntax
=========
CREATE VIEW view_name
[(column_name[,column_name]….)]
[WITH ENCRYPTION]
AS select_statement [WITH CHECK OPTION]

Where:
=======
view_name
==============
specifies the name of the view and must follow the rules for identifiers.

column_name specifies the name of the column to be used in view. If the column_name option is not specified, then the view is created with the same columns as specified in the select_statement.

WITH ENCRYPTION encrypts the text for the view in the syscomments table.

AS specifies the actions that will be performed by the view.

select_statement specifies the SELECT Statement that defines a view. The view may use the data contained in other views and tables.

WITH CHECK OPTION forces the data modification statements to fulfill the criteria given in the SELECT statement defining the view. It also ensures that the data is visible after the modifications are made permanent.