📘Introducing SQL Notebooks: Tell stories using data.Read more →

How to Truncate a Table in Redshift

Be very careful with this command. It will empty the contents of your Redshift table and there is no undo. This is useful in development, but you'll rarely want to do this in production.

TRUNCATE TABLE table_name;

--the TABLE keyword is actually optional:
TRUNCATE table_name;

Ready for a modern SQL editor?