Using ALTER VIEW Statement

SQL view is a virual table so it can be changed using ALTER VIEW statement. Here is the syntax of ALTER VIEW in Microsoft SQL Server (for MySQL see ALTER VIEW in MySQL)

ALTER VIEW view_name [(column [,n])]
[WITH ENCRYPTION | SCHEMABINDING]
AS
select_statement
[WITH CHECK OPTION]

The select statement is optional. The ALTER VIEW statement is used in case you want to retain the permission on the view. If you DROP VIEW and recreate it with CREATE VIEW, all the permissions associated with view will be lost.