How to Truncate a Table in Snowflake

Truncate a Table in Snowflake

We will use the Truncate command to empty the data of our Snowflake table. The syntax for the Truncate:

truncate table name

truncate users1;

If the table has the “ÄUTO_INCREMENT” column, the counter for it will not reset. This behaviour is different from other databases like SQL SERVER, for example, where we don’t require to reset the counter yourself.

Conclusion

Deleting a table and its structure is possible through only the “Truncate” command. I hope this blog offers you sufficient information about Truncate command syntax and working with truncate command.

Snowflake Related Articles

▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop

▶  Snowflake Time Travel

If you have any queries, let us know by commenting below.