SALES: 1-800-867-1380

CREATE VIEW (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

This topic is not maintained. For the current version, see CREATE VIEW (Transact-SQL).

Creates a virtual table that represents the data in one or more tables in an alternative way. CREATE VIEW must be the first statement in a query batch.

Syntax Conventions (Azure SQL Database)

CREATE VIEW [ schema_name . ] view_name [ (column [ ,...n ] ) ] 
[ WITH <view_attribute> [ ,...n ] ] 
AS select_statement 

<view_attribute> ::= 

This syntax diagram demonstrates only the supported arguments and options in Microsoft Microsoft Azure SQL Database.

Microsoft Azure SQL Database does not support the ENCRYPTION argument with the CREATE VIEW statement.

For more information about the arguments and the CREATE VIEW statement, see CREATE VIEW (Transact-SQL) in SQL Server Books Online.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft