How-To Guides / Redshift How to rename a table in Redshift Below is the syntax to rename a table in Redshift database: alter table tablename rename to new_tablename; Share this:Click to share on WhatsApp (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window) Related See also How to drop a materialized view in Redshift database