Alter a View

docs/mindsdb_sql/sql/api/alter-view.mdx

26.1.0352 B

Description

The ALTER VIEW statement updates the query assigned to a view created with the CREATE VIEW command.

Syntax

Here is the syntax:

sql

ALTER VIEW view_name [AS] (
    SELECT * FROM integration_name.table_name
);

--or

ALTER VIEW name 
FROM integration_name (
    SELECT * FROM table_name
);