sql drop data from all tables code example
Example: drop all data from tables
DELETE FROM my_table; -- all rows, needs a COMMIT to validate
TUNCATE TABLE my_table; -- all rows, quicker, no possible roolback
DELETE FROM my_table; -- all rows, needs a COMMIT to validate
TUNCATE TABLE my_table; -- all rows, quicker, no possible roolback