/ 
DBIO-DB2-0.900000
/ DBIO::DB2::Introspect::ForeignKeys

NAME

DBIO::DB2::Introspect::ForeignKeys - Introspect DB2 foreign keys

VERSION

version 0.900000

DESCRIPTION

Fetches foreign-key metadata via SYSCAT.TABCONST joined with SYSCAT.KEYCOLUSE and SYSCAT.REFERENCES. Composite FKs are grouped by constraint name.

METHODS

fetch

my $fks = DBIO::DB2::Introspect::ForeignKeys->fetch($dbh, $schema, $tables);

Returns a hashref keyed by table name, each value an arrayref of FK hashrefs with: constraint_name, from_columns, to_table, to_columns, on_update, on_delete. constraint_name is the canonical FK key blessed by core ADR 0021.

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.