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
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.