/ 
DBIO-MySQL-0.900000
/ DBIO::MySQL::Introspect::Indexes

NAME

DBIO::MySQL::Introspect::Indexes - Introspect MySQL/MariaDB indexes

VERSION

version 0.900000

DESCRIPTION

Fetches index metadata from information_schema.statistics, scoped to the current DATABASE() and filtered to the tables surfaced by DBIO::MySQL::Introspect::Tables. Multi-column indexes are reassembled from their per-column statistics rows in seq_in_index order.

METHODS

fetch

my $indexes = DBIO::MySQL::Introspect::Indexes->fetch($dbh, $tables);

Given the tables hashref from DBIO::MySQL::Introspect::Tables, returns a hashref keyed by table name. Each value is a hashref of index hashrefs keyed by index name, with keys: index_name, is_unique, columns (arrayref), index_type, origin (pk / u / c).

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.