NAME

DBIO::Sybase::Introspect - Introspect a Sybase ASE database via information_schema

VERSION

version 0.900000

DESCRIPTION

DBIO::Sybase::Introspect reads the live state of a Sybase ASE database via the standard SQL INFORMATION_SCHEMA views. It is the source side of the test-deploy-and-compare strategy used by DBIO::Sybase::Deploy.

my $intro = DBIO::Sybase::Introspect->new(dbh => $dbh);
my $model = $intro->model;

Model shape (canonical — single-schema, un-qualified keys):

{
    tables       => { $name => { ... } },
    columns      => { $table => [ { ... }, ... ] },
    indexes      => { $table => { $name => { ... } } },
    foreign_keys => { $table => [ { constraint_name, from_columns,
                                    to_table, to_columns,
                                    on_update, on_delete } ] },
}

The FK rows in foreign_keys are pre-grouped per constraint (one entry per FK, with from_columns / to_columns as arrayrefs) so the default "table_fk_info" in DBIO::Introspect::Base contract method applies unchanged. Each entry also carries constraint_name -- the live, server-assigned name -- so the diff layer can DROP/ALTER a foreign key by its real name instead of a generated one (see ADR 0021; constraint_name is FK metadata, not a compared attribute).

ATTRIBUTES

schema

Schema name to introspect. Defaults to dbo.

METHODS

view_definition

SQL text of the view definition, or undef.

• DBIO::Sybase::Deploy - uses this class for test-deploy-and-compare

• DBIO::Sybase::Diff - compares two models produced by this class

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.