fetching the primary key of a table

Hi,
When I use the following syntax with Oracle, I am able to retrieve the
primary key. But the same syntax doesn't seem to work with MySql.

@primary_key = $dbh->primary_key($catalog,$schema,$table);

With my Oracle database, this translates to:
@primary_key = $dbh-> primary_key(undef,'JAGDATA_TRANSFER','OR
IG');

With my MySql database, this translates to:
@primary_key = $dbh-> primary_key(undef,'jagdata_transfer','or
ig');

What am I doing wrong?

On Wed, 2008-04-30 at 21:30 +0530, jagdish eashwar wrote:

> Hi,
> When I use the following syntax with Oracle, I am able to retrieve the
> primary key. But the same syntax doesn't seem to work with MySql.
>
> @primary_key = $dbh->primary_key($catalog,$schema,$table);
>
> With my Oracle database, this translates to:
> @primary_key = $dbh-> primary_key(undef,'JAGDATA_TRANSFER','OR
IG');
>
> With my MySql database, this translates to:
> @primary_key = $dbh-> primary_key(undef,'jagdata_transfer','or
ig');
>
> What am I doing wrong?

I use:
$dbh->column_info( undef, $schema, $table, '%' );

Dan