Finding field name of the primary key

[Dudsmack]

How can I find the field name of the primary key?

[jkoopmann]

for oracle, you could run some sql like this:
select dc.table_name,dc.constraint_name,
dcc.column_name, dcc.position
from dba_constraints dc, dba_cons_columns dcc
where dc.constraint_type = 'P'
and dc.constraint_name = dcc.constraint_name
and dc.table_name = '<table_name>'
order by dcc.position

[rmiao]

For MS sql, you can try this:

select CONSTRAINT_NAME, table_name, column_name from information_schema.key_column_usage where CONSTRAINT_NAME like 'pk%'

[Dudsmack]

Sorry, I guess I should have specified. I'm using MySQL.