SQL Server Transact Basic to Expert - Create to alter an existing view

This blog show how to alter an existing view in sql using the query analyser

Syntax:

ALTER VIEW schemaname.viewname  ( Columns)
WITH [ ENCRYPTION ] [ SCHEMABINDING ] [ VIEW_METADATA ]
AS selectStatement
GO


Example:

ALTER VIEW dbo.vemptable
AS
SELECT   Empname, Empsal, Empstate from emptable
GO
Ebook Download
View all
Learn
View all