使用SQL创建视图的语法结构

最简洁语法结构:

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 

Add comment

Loading