[Check if foreign key exits] #php #laravel

ForeignKey.php

<?php

declare(strict_types=1);

namespace Database\Helpers;

use Illuminate\Support\Facades\Schema;

class ForeignKey
{
    public static function keyExists(string $table, string $foreignKey, ?string $database = null): bool
    {
        $keys = Schema::getConnection()->getDoctrineSchemaManager()->listTableForeignKeys($table, $database);
        $foreign = collect($keys)->map(fn ($key) => $key->getName());

        return $foreign->contains($foreignKey);
    }
}

// create helper folder in database folder
// add "Database\\Helpers\\": "database/helpers/" to composer psr-4 section