/ 
DBIO-SQLite-0.900000
/ DBIO::SQLite::Introspect::Indexes

NAME

DBIO::SQLite::Introspect::Indexes - Introspect SQLite indexes

VERSION

version 0.900000

DESCRIPTION

Fetches index metadata via PRAGMA index_list() and PRAGMA index_info(), plus the original CREATE INDEX statement from sqlite_master for partial / expression indexes. Skips auto-generated indexes (PRIMARY KEY, UNIQUE constraint indexes).

METHODS

fetch

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

Returns a hashref keyed by table name. Each value is a hashref keyed by index name. Each index entry has: index_name, is_unique, columns (arrayref), sql (CREATE statement, may be undef for auto-generated UNIQUE indexes), origin (c=CREATE, u=UNIQUE, pk=PRIMARY KEY), partial (1 if WHERE clause present).

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.