NAME

DBIO::MSSQL::Diff::Table - Diff operations for MSSQL tables

VERSION

version 0.900007

DESCRIPTION

Table-level diff operations for MSSQL. Handles CREATE TABLE, DROP TABLE. A model entry with kind => 'view' is not a table: it gets neither statement (see "view_names"). create ops capture the target columns so as_sql can emit the full inline definition. The table is created without its foreign keys: they are ALTER TABLE ... ADD CONSTRAINT operations of DBIO::MSSQL::Diff::ForeignKey, which DBIO::MSSQL::Diff runs after every table exists (an inline FOREIGN KEY needs its target to exist already, and two new tables cannot reference each other that way). Built on DBIO::Diff::Op (the create/drop walk and accessor/summary plumbing).

METHODS

view_names

my @views = DBIO::MSSQL::Diff::Table->view_names($tables, ...);

The sorted names of the entries of the given tables sections of a model that are views (kind => 'view'). DBIO::MSSQL::Introspect::Tables keeps views in tables beside the tables. A view is no table: this class gives it no statement, DBIO::MSSQL::Diff::View does. DBIO::MSSQL::Diff::Column and DBIO::MSSQL::Diff::Index use this to leave out what hangs off a view.

diff

as_sql

summary

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.