NAME

DBIO::Informix::Introspect::Tables - Introspect Informix tables and views

VERSION

version 0.900007

DESCRIPTION

Fetches Informix table and view metadata from systables.

Measured against Informix 15.0.1. User tables are the ones with tabid >= 100, whoever owns them (the database owner, usually the connecting user, is informix, as is the owner of the catalog). $schema is validated (\w+) and used as the database qualifier, "$schema":informix.systables.

METHODS

fetch

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

Returns a hashref keyed by table name. Each value is a hashref with keys: table_name, kind (table or view), owner, and for a view its definition (the CREATE VIEW statement of the server, blanks collapsed).

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.