note Tux <p>In that case, dropping the database and recreating it is most likely the fastest solution. Database drops in PostgreSQL and MySQL/MariaDB are almost instant. In Oracle it takes ages to (re)create a database.</p> <p>To get all tables, why not use the [https://metacpan.org/module/DBI#89|DBI::tables]? That way you don't have to dig into database specific calls.</p> <p>If you still want to delete in stead of re-create, why use a <c>prepare/execute</c> combo instead of just [https://metacpan.org/module/DBI#67|do]?</p> <code> $dbh->do ("truncate table $_") for $dbh->tables (undef, undef, undef, "TABLE");</code> <p>or</p> <code> $dbh->do ("delete from $_") for $dbh->tables (undef, undef, undef, "TABLE");</code> <p>In other databases, you could use <c>delete from table cascade</c>, but iirc that syntax is not supported by mysql where you'd have to create the table to know about cascading deletes.</p> <!-- Node text goes above. Div tags should contain sig only --> <div class="pmsig"><div class="pmsig-200365"> <br /> Enjoy, Have FUN! H.Merijn </div></div> 994479 994505