We will use the Truncate command to empty the data of our Snowflake table. The syntax for the Truncate:
truncate table name
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.
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
If you have any queries, let us know by commenting below.
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
|Snowflake Training||Sep 26 to Oct 11||View Details|
|Snowflake Training||Sep 30 to Oct 15||View Details|
|Snowflake Training||Oct 03 to Oct 18||View Details|
|Snowflake Training||Oct 07 to Oct 22||View Details|
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.
Copyright © 2013 - 2023 MindMajix Technologies