The TRUNCATE statement

Another statement that can also change the data but not the data structure is TRUNCATE. It clears the table completely and almost instantly. It has the same effect as the DELETE statement without the WHERE clause. So, it is useful on large tables:

car_portal=> TRUNCATE TABLE car_portal_app.a;
TRUNCATE TABLE
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset