Select Primary Key

[Rich]

Hi folks.  How can I select primary key from a table?  I can't find  
any syntax out of show fields from tablename, and the 'key' field =  
"PRI".  Just seems to be a bit much.

Any takers?
Cheers


Rich in Toronto (cold)



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]