How to catch errors when performing a migration via $this->execute(); yii2?

Question

Yii

I want to use raw SQL

public function up()
    {
        $sql = <<<SQL
CREATE TABLE .....
SQL;

        try{
            $this->execute($sql);
        }catch (\yii\base\Exception $e){
            echo $e->getMessage();
            return false;
        }

    }

This is how I try to catch errors. Sometimes they are caught, sometimes they are not :(. It can easily omit an error from FOREIGN KEY registration, for example. How to catch all errors?

Answer 1

Yii2 Docs: Transactional Migrations