logo-MindMajix
Home  >  Blog  >   Snowflake  > 

How to Truncate a Table in Snowflake

When we want to delete the entire content of a table at a time, we will use the “Truncate” command. In this blog, you will learn to use the Truncate command and delete the data.

Rating: 4.2
  
 
247
  1. Share:
Snowflake Articles
Snowflake Community
Snowflake Quiz

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.

MindMajix YouTube Channel

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.

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
Snowflake TrainingNov 26 to Dec 11
Snowflake TrainingNov 29 to Dec 14
Snowflake TrainingDec 03 to Dec 18
Snowflake TrainingDec 06 to Dec 21
Last updated: 24 November 2022
About Author
Keerthi Sai

Keerthi Sai is a Senior Writer at Mindmajix with tons of content creation experience in the areas of cloud computing, BI, Perl Scripting. She also creates content on Salesforce, Microstrategy, and Cobit.