.rename materialized-view

Renames a materialized view.

Requires Database Admin or materialized view admin permissions.

Syntax

.rename materialized-view OldName to NewName

Properties

Property Type Description
OldName String Name of the materialized view to rename.
NewName String New name to assign to the view.

Returns

The command returns all materialized views in the database, after the rename, which is the output of the show materialized view command.

Example

.rename materialized-view ViewName to NewName