Re: Show create table equivalent

In mclient use \d \d schema or \d schema table On 23/09/14 14:06, Vijay Krishna wrote:

Yes. I am also looking for the "show create" equivalent for quite sometime.

Its difficult each time to query the sys tables to know the table meta data along with its key constraints. There should be a better way.

Can someone please help??

Thanks & Regards,

Vijayakrishna.P. Mobile : 9500402305.

On Tue, Sep 23, 2014 at 3:13 PM, Guillaume Bassot mailto:gbassot@inbox.fr> wrote:

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 http://tbl.id=col.table_id) WHERE tbl.name http://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 mailto: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 mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

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