How to check foreign keys?

[JenuelDev]

From laravel 4 to 9. It seems there has been no checker for the schema to check foreign keys. I was hoping from v4 to 9 to have something like this. But it seems until now, there is no function. I need help,

The Function I has hoping for:

Schema::hasForeign('<table name>', ['<column name>']); // that will return true or false

[henzeb]

It's a bit hacky, but this may be a solution.

$doctrineTable = Schema::getConnection()->getDoctrineSchemaManager()->listTableDetails('table_name');

$doctrineTable->hasForeignKey('foreignKeyName');

[JenuelDev]

thanks mate!, that is what I did, but I have to go over my database and check for the key.. it would be awesome if I can just add the column name and automatically check the foreign key.,

[henzeb]

With getForeignKeyColumns() you can get an array of columns who are involved in a foreign key constraint.

With getForeignKeys() you get an arrray of ForeignKeyConstraint which has a method getLocalColumns with an array you can use to check if the column you want is involved.

I agree it's a little too much for something so simple, and we cannot add macro's to the Schema builder.

[megabyte-0]

In laravel 11, where the getDoctrineSchemaManager is no longer available in \Illuminate\Database\Schema\Builder, there is Schema::getForeignKeys($table).
I use it like this:

    protected array $foreignKeyCache = [];

    protected function getForeignKeyByColumns(string $table, array $columns): ?array
    {
        $delimiter = '|';
        $glue = fn($columns) => collect($columns)->join($delimiter);
        if (! isset($this->foreignKeyCache[$table])) {
            $this->foreignKeyCache[$table] = collect(Schema::getForeignKeys($table))->keyBy(
                fn (array $foreignKeyItemRecord) => $glue($foreignKeyItemRecord['columns'])
            )->toArray();
        }
        return $this->foreignKeyCache[$table][$glue($columns)] ?? null;
    }