Data definition
ALTER VIEW
Reference and syntax for the ALTER VIEW command.
Updates the specified VIEW.
ALTER VIEW OWNER TO
Change the owner of a view. The current owner of a view can be viewed in the information_schema.views view on view_owner column.
check ownership page for more info.
Syntax
Parameters
| Parameter | Description |
|---|---|
<view> | Name of the view to change the owner of. |
<user> | The new owner of the view. |