TYPO3, DBAL: TRUNCATE table

myFile.php

## THIS IS ONLY TO TRUNCATE A TABLE COMPLETELY

$tablename = 'xyz'

$driver = new \Doctrine\DBAL\Driver\Mysqli\Driver;
$queryBuilder = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance(
    \TYPO3\CMS\Core\Database\Query\QueryBuilder::class,
    \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance(
        \TYPO3\CMS\Core\Database\Connection::class, $GLOBALS['TYPO3_CONF_VARS']['DB']['Connections']['Default'], $driver
    )
);
$concreteQueryBuilder = $queryBuilder->getConcreteQueryBuilder();
$concreteQueryBuilder->delete($tablename);