Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
ALTER VIEW
On this page
The ALTER VIEW command atomically replaces a view with a new view defined by a SELECT statement.ALTER VIEW is an online operation and will not cause concurrently executing queries to fail.
Syntax
ALTER
[DEFINER = { <user> | CURRENT_USER }]
[SCHEMA_BINDING = { ON | OFF }]
VIEW <view_name>
AS <select_statement>Remarks
-
ALTER VIEWatomically replaces view<view_with a new view defined byname> <select_.statement> -
ALTER VIEWprivileges are granted only to the designer of the view . -
The
DEFINERclause (ALTER DEFINER = <user>@<host> VIEW <viewname> AS SELECT .) specifies the user that should be used for security checks when a view is referenced by a query.. . The default value is CURRENT_.USER -
When
SCHEMA_is set toBINDING ON, objects referenced by the view cannot be dropped if the view exists; you need to drop the view before dropping these objects.By default, SCHEMA_is set toBINDING OFF. -
Refer to the Permissions Matrix for the required permissions.
Examples
ALTER VIEW view_name AS SELECT * FROM table_name WHERE user_id = "real_person";
Related Topics
Last modified: