This topic has not yet been rated - Rate this topic

CREATE VIEW (Windows Azure SQL Database)

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 (Windows 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 ] }

Arguments

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.

Concepts

Partially Supported Transact-SQL Statements (Windows Azure SQL Database)
Transact-SQL Reference (Windows Azure SQL Database)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD