Switch to: V9V8V7V6V5

Differences

This shows you the differences between two versions of the page.

valentina:vcomponents:vsql:reference:truncate [2017/02/04 06:45]
127.0.0.1 external edit
valentina:vcomponents:vsql:reference:truncate [2019/02/12 11:46] (current)
rz
Line 1: Line 1:
====== TRUNCATE ====== ====== TRUNCATE ======
-Speedy way to delete all records of a table. +The speedy way to delete all records of a table.
-\\ +
-\\+
 +
 +===== Syntax =====
<code> <code>
Line 20: Line 20:
===== Restrictions ===== ===== Restrictions =====
-Table should satisfy the following requirements: +The table should satisfy the following requirements:
  - there are no on-delete triggers;   - there are no on-delete triggers;
  - there are no links.   - there are no links.