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.

 
 

Share your thought