MySQL Bugs: #26448: Document difference (if any) between ALTER VIEW and CREATE OR REPLACE VIEW

Bug #26448	Document difference (if any) between ALTER VIEW and CREATE OR REPLACE VIEW
Submitted:	16 Feb 2007 15:49	Modified:	19 Feb 2007 0:48
Reporter:	Alex Rytov	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:	5.1.15	OS:
Assigned to:	Paul DuBois	CPU Architecture:	Any
Tags:	ALTER VIEW, CREATE OR REPLACE

Description:

The ALTER VIEW... statement and the CREATE OR REPLACE VIEW... variant of CREATE VIEW seem to be identical, but it would be good to have this confirmed in the documentation or, if there is any difference between the functionality of these two forms, to have it described.

How to repeat:
see the docs

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

If the table exists then ALTER VIEW and CREATE OR REPLACE VIEW are the same.
But if there is no such table ALTER VIEW fails and CREATE OR REPLACE
VIEW works as CREATE VIEW.