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
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 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=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
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 <gbassot@inbox.fr 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
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 <gbassot@inbox.fr 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
participants (4)
-
Guillaume Bassot -
Martin Kersten -
Radovan Bičiště -
Vijay Krishna