ALTER TABLE

The ALTER TABLE command in MotherDuck works the same as in DuckDB. See ALTER TABLE in the DuckDB documentation for complete details.

Rename a view

In a MotherDuck catalog, ALTER TABLE ... RENAME TO also renames a view:

ALTER TABLE my_view RENAME TO my_renamed_view;