Finding the Primary Key

[Roost3r]

Is there a way to find the primary key(column name) in a table via a SQL statement? Show Primary From Table ???

[raf]

Check out

there is some example code to
http://www.php.net/manual/en/function.mysql-field-flags.php