retrieve mysql Field informs (defaultvalue, foreignfield)

[TNL]

hi,

how can I retrieve information of a mysql Field such as its defaultvalue, or if it is a foreign key (a relation to a master table) and the master table name, master field?

I have tried the mysql_* functions.

Thanks
TNL

[liquorvicar]

only INNOdb tables support foreign keys in MySQL.
MySQL docs