/ 
DBIO-MSSQL-0.900000
/ DBIO::MSSQL::Introspect::ForeignKeys

NAME

DBIO::MSSQL::Introspect::ForeignKeys - Introspect MSSQL foreign keys

VERSION

version 0.900000

DESCRIPTION

Fetches foreign key metadata via INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS and related views.

METHODS

fetch

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

Given the tables hashref from DBIO::MSSQL::Introspect::Tables, returns a hashref keyed by table name. Each value is an arrayref of foreign key hashrefs with keys: constraint_name, from_columns, to_columns, to_table, to_schema, on_delete, on_update, is_deferrable.

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.