NAME

DBIO::Informix::Introspect::Indexes - Introspect Informix indexes

VERSION

version 0.900007

DESCRIPTION

Fetches index metadata via sysindexes. The index-to-column link is sysindexes.part1 .. part16, each a syscolumns.colno of the same table; a negative part is a descending column (the absolute value is the column number), 0 is unused. Columns come out in part order.

Measured against Informix 15.0.1. Not handled: functional / opaque-type indexes (whose parts do not name plain columns). Indexes the server created for a constraint (named like " 136_41", listed as sysconstraints.idxname) are left out: the primary and foreign keys are modelled as such, and the names differ from one database to the next, so diffing them by name would drop and recreate them.

METHODS

fetch

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

Returns a hashref keyed by table name. Each value is a hashref keyed by index name, with keys: index_name, unique, columns.

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.