Mega Code Archive

 

Categories / MSSQL Tutorial / View

 

View creation syntax

CREATE VIEW <view name> AS <SELECT statement> The above syntax just represents the minimum, of course, but it's still all we need in a large percentage of the situations. The more extended syntax looks like this: CREATE VIEW <view name> [(<column name list>)] [WITH [ENCRYPTION] [,SCHEMABINDING] [, VIEW_METADATA]] AS <SELECT statement> WITH CHECK OPTION