MySQL Tutorial/View/Alter View

ALTER VIEW statement

The ALTER VIEW statement is the same as the CREATE statement, except for the omission of the OR REPLACE option.

The ALTER VIEW statement does the same thing as CREATE OR REPLACE.

The full ALTER statement looks like this:

   <source lang="sql">

ALTER [<algorithm attributes>] VIEW [<database>.]< name> [(<columns>)] AS <SELECT statement> [<check options>]</source>