Subject: | Support for TRUNCATE TABLE |
TRUNCATE TABLE is currently not supported, but should be easy to
implement. It is a SQL:2008 standard command now. At the very least,
the TRUNCATE sub could just reword it into "DELETE FROM X;" and let
delete handle it. Though, if there's a more effective method of
dropping everything, that should be called instead.
Actually, there's a "truncate" method set to be defined within the
DBD::XXX:Table module (according to SQL::Eval), so the TRUNCATE sub
should just call "$table->truncate($data);", if it is available.