TRUNCATE TABLE

The TRUNCATE statement deletes a table from the database. This means that there will be no data from the table in the database, nor will there be a defined table structure.

Structure:
TRUNCATE TABLE table_name;

 

Example1:

TRUNCATE TABLE Staff;

 

Leave a Comment

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