Show create table equivalent

Hello everyone,

I'm looking for the mysql show create table equivalent. I need this as a query to get the result in a php script. (I already found how to do this with mclient and msqldumq)

I found this query that need to be parsed to recreate the "CREATE TABLE".

SELECT * FROM SYS.tables tbl INNER JOIN SYS.columns col ON (tbl.id=col.table_id) WHERE tbl.name='exemple';

But i still miss the table's constraints (primary key, unique key)

Could you tell me where to find this information ?

Thank you for helping.

Guillaume BASSOT Web Developer +33 (0)1 55 48 02 82 gbassot@inbox.fr

30, rue Vincent Moris 92240 Malakoff - France Fax : +33 (0)1 55 48 02 79