Re: [GENERAL] SQL Query for Foreign constraint

2014-03-20 Thread Andy Colson
On 3/20/2014 4:45 PM, Raymond O'Donnell wrote: On 20/03/2014 07:48, Bhim Kumar wrote: Hi sir Currently I am using following query on mysql : * SHOW TABLES; ---> To get list of table in a particular db. Assuming you're using psql, did you take the advice you're given on connection and type

Re: [GENERAL] SQL Query for Foreign constraint

2014-03-20 Thread Raymond O'Donnell
On 20/03/2014 07:48, Bhim Kumar wrote: > Hi sir > > Currently I am using following query on mysql : > > * SHOW TABLES; ---> To get list of table in a particular db. Assuming you're using psql, did you take the advice you're given on connection and type "help"? Anyway, to see a list of tables

[GENERAL] SQL Query for Foreign constraint

2014-03-20 Thread Bhim Kumar
Hi sir Currently I am using following query on mysql : * SHOW TABLES; ---> To get list of table in a particular db. * SELECT TABLE_NAME, CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME from information_schema.key_column_usage WHERE constraint_schema ='myDBName';