Deleting All Rows from a Database Table
All the rows in a table can be deleted either by using the
TRUNCATE or DELETE SQL statement. TRUNCATE is faster
than DELETE since it does not generate rollback information, does
not fire any delete trigger, and does not record any information.
This example deletes all the rows from a database table called
my_table.
try {
Statement stmt = connection.createStatement();
// Use TRUNCATE
String sql = "TRUNCATE my_table";
// Use DELETE
sql = "DELETE FROM my_table";
// Execute deletion
stmt.executeUpdate(sql);
} catch (SQLException e) {
}
Post a comment