<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 
GO

CREATE VIEW CustomerPhoneList_vw AS SELECT CustomerName, Contact, Phone FROM Customers