Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

CREATE VIEW (Azure SQL Database)

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

ImportantImportant
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 
[ WITH CHECK OPTION ] [ ; ]

<view_attribute> ::= 
{
    [ SCHEMABINDING ]
    [ VIEW_METADATA ] }

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

Windows 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.