SQL Server Transact Basic to Expert - Create basic View

This blog show how to create a basic view in sql server using query analyzer

Syntax:
CREATE VIEW [ schemaname . ] viewname [ (columnNames) ]
[ WITH [ ENCRYPTION ] [ SCHEMABINDING ] [ VIEWMETADATA ]]
AS selectStatement
[ WITH CHECK OPTION ]


Example:
Create View dbo.vEmptable
AS
Select empid, empname, empsal from emptable
GO


Ebook Download
View all
Learn
View all