|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.