Hi, AFAIK there is not such function in the SQL. You can download source code of JDBC driver and dig into MonetDatabaseMetaData class. It contains SQL to retrieve column definitions etc. Based on that you can create your function in MonetDB to return the definition in format of SQL DDL. Radovan On 09/23/2014 02:06 PM, 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