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;

Real-time SQL collaboration is here

Get started with PopSQL and Redshift in minutes