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

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list