What I do is select from one of the system tables. Your system tables are listed by something like this: select name from systables where name like 'SYS%'; Under as400 the primary key info is in: syskeycst Under sqlbase the primary key info is in: syspkconstraints Every db seems to be different. But it looks like they all (?) use sys* for the system tables. bob Mike Kangas wrote: > > How do I find what fields are the primary keys of a table through > Win32::ODBC? > > I found the odbc_primarykeys function that PHP uses but can't find anything > for Perl. THIS CAN'T BE!! > > Thanks ahead of time. > Mike Kangas > > _______________________________________________ > Perl-Win32-Users mailing list > [EMAIL PROTECTED] > http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users -- [EMAIL PROTECTED] [EMAIL PROTECTED] http://people.ne.mediaone.net/rsdavis http://rsdavis.ne.mediaone.net n42 58.476 w70 55.454 _______________________________________________ Perl-Win32-Users mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users