Show create table equivalent

23 Sep 2014

      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

Show create table equivalent

Guillaume Bassot