SQL Truncate Table

OBJECTIVE

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


Leave a Reply

Your email address will not be published. Required fields are marked *