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.

--syntax
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
Shared queries and folders ✅ Version history ✅ One-click connection to Snowflake ✅
Get more done, together, with PopSQL and Snowflake