How to Rename a Table in Redshift

The rename is metadata only and completes instantly. Regular views are bound to the underlying object, so they follow the rename and keep working. Late-binding views resolve names at query time and will fail the next time they run. This statement cannot move the table into a different schema.

ALTER TABLE orders RENAME TO customer_orders;

Move to another schema

SET SCHEMA moves the table without copying data. Both schemas must be in the same database and you need CREATE on the target. Anything relying on search_path rather than a fully qualified name stops finding the table, which is the usual way this quietly breaks dashboards.

ALTER TABLE public.orders SET SCHEMA archive;