.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