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;
Better SQL for the people
Get more done with PopSQL and Redshift