NAME

DBIO::MSSQL::Introspect - Introspect a Microsoft SQL Server database via information_schema

VERSION

version 0.900000

DESCRIPTION

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

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

Model shape mirrors DBIO::SQLite::Introspect:

{
    tables       => { $name => { ... } },
    columns      => { $table => [ { ... }, ... ] },
    indexes      => { $table => { $name => { ... } } },
    foreign_keys => { $table => [ { ... }, ... ] },
}

ATTRIBUTES

schema

Schema name to introspect. Defaults to dbo.

NORMALIZED INTROSPECTION CONTRACT

The seven DBIO::Introspect::Base contract methods (table_keys, table_columns, table_columns_info, table_pk_info, table_uniq_info, table_fk_info, table_is_view) are inherited unchanged from the base: they are pure reads over the canonical "model" this class builds, so this introspector serves as a high-fidelity source for DBIO::Generate with no driver-specific override. Two model details make the defaults correct here: DBIO::MSSQL::Introspect::Columns emits the canonical is_auto_increment flag (alongside the MSSQL-native is_identity), and DBIO::MSSQL::Introspect::Indexes already excludes primary-key indexes, so table_uniq_info never double-reports the PK.

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

• DBIO::MSSQL::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.