SQL Truncate Table

In this chapter you will learn:
About truncate table
Syntax of truncate table
Example of truncate table

About truncate table

SQL statement truncate table is used to delete the records of the table but the table structure is not deleted and you can again insert values in that table.

Example of truncate table

truncate table table_name

Example of top statement

truncate table employee_detail
truncate-table
SUMMARY

In this chapter, you have learned about truncate table statement which is used to delete the all records of the table without deleting the existence of the table.

More Articles

 
 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.