Eksportér (0) Udskriv
Udvid alt
EN
Dette indhold er ikke tilgængeligt på dit sprog, men her er den engelske version.

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

Fællesskabsindhold

Tilføj
Vis:
© 2014 Microsoft