How to Truncate a Table in Snowflake

Be super careful with TRUNCATE command. It will empty the content of your Snowflake table. This is useful in development, but you'll seldom want to do this in production.

truncate table_name;

truncate users;

If the table contains an AUTO_INCREMENT column, the counter for it will not get reset. Note that this behavior is different vs some other databases like SQLServer for example, where you don't need to reset the counter yourself.

database icon
Real-time SQL collaboration is here
Get started with PopSQL and Snowflake in minutes