How can I rename a table in MonetDB?

Question

How can I rename a table in monetdb? The typical SQL statement ALTER TABLE name RENAME TO new_name is not supported.

Answer 1

Also consider creating a SQL view with the new name, e.g. CREATE VIEW newname AS SELECT * FROM oldname;

This has the advantage of no data being copied around at all.