[TYPO3-dev] How standard compliant is "truncate"?

[Peter Kuehn [wmdb]]

Hi yall,

some questions to those, who know more about databases than i do:

How standard compliant is "truncate table"?
On which DBMS will it work or not work?
Is ADODB able to rewrite it where it does not work?

Background:
I plan to submit a patch request for t3lib_tcemain->clear_cacheCmd() 
where $cacheCmd=='all', if truncate table will not break DBAL.
The currently used "DELETE FROM cache_*" calls end up as an entry in 
slow query logs on larger installs.

thnx in advance
pekue