/ 
DBIO-Sybase-0.900000
/ DBIO::Sybase::Introspect::Columns

NAME

DBIO::Sybase::Introspect::Columns - Introspect Sybase ASE columns

VERSION

version 0.900000

DESCRIPTION

Fetches column metadata via INFORMATION_SCHEMA.COLUMNS. Primary key information is joined in via INFORMATION_SCHEMA.KEY_COLUMN_USAGE + INFORMATION_SCHEMA.TABLE_CONSTRAINTS.

METHODS

fetch

my $columns = DBIO::Sybase::Introspect::Columns->fetch($dbh, $schema, $tables);

Given the tables hashref from DBIO::Sybase::Introspect::Tables, returns a hashref keyed by table name. Each value is an arrayref of column hashrefs in ordinal_position order with keys: column_name, data_type, not_null, default_value, is_pk, pk_position, is_auto_increment.

Identity (autoincrement) columns are detected from the syscolumns identity status bit (0x80), which is not exposed through INFORMATION_SCHEMA. The detection query is best-effort: if it fails (insufficient privileges, or a non-ASE server), columns are still returned with is_auto_increment defaulting to 0.

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.