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.