NAME

DBIO::Informix::Introspect::UniqueConstraints - Introspect Informix unique constraints

VERSION

version 0.900007

DESCRIPTION

Fetches the unique constraints of the tables via sysconstraints (constrtype = 'U'). The columns are the key of the index the server holds for the constraint (sysconstraints.idxname to sysindexes.part1 .. part16 to syscolumns.colno). The index itself is not an entry of DBIO::Informix::Introspect::Indexes, which leaves out every index a constraint owns.

Measured against Informix 15.0.1.

METHODS

fetch

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

Returns a hashref keyed by table name (tables without a unique constraint have no key). Each value is an arrayref of hashrefs with the keys constraint_name and 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.