<p>最简洁语法结构:</p>
CREATE VIEW <view name> AS <SELECT statement>
扩展的语法结构如下所示:
CREATE VIEW [schema_name].<view name> [(<column name list>)] [WITH [ENCRYPTION] [, SCHEMABINDING] [, VIEW_METADATA]] AS <SELECT statement> WITH CHECK OPTION
示例:
USE Accounting GOCREATE VIEW CustomerPhoneList_vw AS SELECT CustomerName, Contact, Phone FROM Customers