NAME

DBIO::MSSQL::Result - MSSQL-specific Result component for DBIO

VERSION

version 0.900000

DESCRIPTION

DBIO::MSSQL::Result is a DBIO Result component that adds MSSQL-native metadata to a result class: standalone indexes, including clustered/nonclustered hints. It is the counterpart to DBIO::MySQL::Result / DBIO::PostgreSQL::Result and is read by DBIO::MSSQL::DDL when generating install DDL.

Load it with:

package MyApp::Schema::Result::User;
use base 'DBIO::Core';
__PACKAGE__->load_components('MSSQL::Result');

__PACKAGE__->table('users');

__PACKAGE__->mssql_index('idx_users_name' => {
    columns => ['name'],
});

__PACKAGE__->mssql_index('idx_users_email' => {
    unique  => 1,
    kind    => 'nonclustered',
    columns => ['email'],
});

METHODS

mssql_index

__PACKAGE__->mssql_index('idx_users_email' => {
    unique  => 1,
    kind    => 'nonclustered',
    columns => ['email'],
});

Get or set the definition for a named MSSQL index. The definition hashref accepts:

columns - ArrayRef of column names

unique - set to true for a UNIQUE index

kind - clustered or nonclustered

mssql_indexes

my $all = $class->mssql_indexes;

Returns a copy of all index definitions registered on this result class. Consumed by DBIO::MSSQL::DDL.

• DBIO::MSSQL::DDL - consumes mssql_indexes

• DBIO::MySQL::Result - the MySQL counterpart

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.