Mega Code Archive

 

Categories / MSSQL Tutorial / View

 

The syntax of the CREATE VIEW statement

CREATE VIEW view_name [(column_name_1 [, column_name_2]...)] [WITH {ENCRYPTION|SCHEMABINDING|ENCRYPTION,SCHEMABINDING}] AS select_statement [WITH CHECK OPTION]