Comments on public interface: List foreign key constraints in Oracle and MySQL

Juste on thing : for the oracle version, you forgo...

2012-02-03T15:40:31.643+01:00

Juste on thing : for the oracle version, you forgot to specify the owner in the "on" clauses, it may be important in most cases.

Ho my god, the holy solution is right here ! I was...

2012-02-03T15:35:56.132+01:00

Ho my god, the holy solution is right here ! I was trying to build the same query, but it seems that i'm not good enough :D

Thanks dude !

thanks for sharing!

2012-01-20T11:22:32.379+01:00

thanks for sharing!

awesome... thats what i needed. Makes my task so s...

2011-09-26T07:23:04.900+02:00

awesome... thats what i needed. Makes my task so simple.. :)

Perfect! Thank you :)

2011-09-13T12:35:50.197+02:00

Perfect! Thank you :)

I know it's not your fault you're using Or...

2011-09-13T12:00:09.455+02:00

I know it's not your fault you're using Oracle.

That's perfect ))

yoyo.. you rocks man.

2011-07-11T06:52:22.519+02:00

yoyo.. you rocks man.

brilliant.

2011-05-29T21:15:52.462+02:00

brilliant.

from argentina.Me was very useful Thanks

2010-12-09T00:26:56.457+01:00

from argentina.Me was very useful
Thanks

Thanks a bunch. I'm new to MySQL and not very ...

2010-12-02T03:18:15.407+01:00

Thanks a bunch. I'm new to MySQL and not very fond of the free WorkBench. Glad I found a way to at least see the FKs that are actually referenced in the data.

Thanks. It worked for me.

2010-08-10T18:42:17.434+02:00

Thanks. It worked for me.

Thanks. It's very useful.

2010-07-04T07:42:54.245+02:00

Thanks. It's very useful.

Thanks :) one more to you growing list ;)

2010-04-06T23:50:58.601+02:00

Thanks :) one more to you growing list ;)

Just what I needed :)

2010-04-05T13:57:43.228+02:00

Just what I needed :)

Now does anyone know how to modify the data type o...

2010-02-02T19:45:16.673+01:00

Now does anyone know how to modify the data type of a column/field in MySQL which has a foreign key constraint to another table? A simple 'ALTER TABLE table_name MODIFY column_name new_column_type' throws an errorno: 150 due to the foreign key constraint.

Is there a way to get around this by doing something like cascading the changes to the other dependent tables?

Thanks,
Karthik

Clear, concise and right to the point. Thanks for ...

2010-02-02T19:38:23.309+01:00

Clear, concise and right to the point. Thanks for this helpful tip and thanks Google for bringing your page to the top :). The search phrase I used was "mysql foreign key details" (without the double quotes).

thx from Latvia

2010-01-03T16:17:47.202+01:00

thx from Latvia

thanks dude....

2009-11-19T07:32:49.896+01:00

thanks dude....

beautiful-thanks!

2009-10-06T21:19:14.137+02:00

beautiful-thanks!

Thank you very much

2009-09-16T14:36:55.068+02:00

Thank you very much

thanks man.. it s helpful.. I am also having the b...

2009-09-09T07:57:37.400+02:00

thanks man.. it s helpful.. I am also having the blog won oracle database www.blogskies.com visit it when you get time.. thx.

I think you deserve a couple of wings or so... Ty!...

2009-04-29T17:42:00.000+02:00

I think you deserve a couple of wings or so...
Ty!!!

Thank you.Its very useful to me

2009-03-09T10:42:00.000+01:00

Thank you.Its very useful to me

Maybe the oracle is slightly sophisticated than my...

2009-02-25T02:45:00.000+01:00

Maybe the oracle is slightly sophisticated than mysql :)

Thanks for this dude,

Sean

2009-02-24T23:47:00.000+01:00

Thanks for this dude,

Sean

Comments on public interface: List foreign key constraints in Oracle and MySQL

Juste on thing : for the oracle version, you forgo...

Ho my god, the holy solution is right here ! I was...

thanks for sharing!

awesome... thats what i needed. Makes my task so s...

Perfect! Thank you :)

I know it's not your fault you're using Or...

yoyo.. you rocks man.

brilliant.

from argentina.Me was very useful Thanks

Thanks a bunch. I'm new to MySQL and not very ...

Thanks. It worked for me.

Thanks. It's very useful.

Thanks :) one more to you growing list ;)

Just what I needed :)

Now does anyone know how to modify the data type o...

Clear, concise and right to the point. Thanks for ...

thx from Latvia

thanks dude....

beautiful-thanks!

Thank you very much

thanks man.. it s helpful.. I am also having the b...

I think you deserve a couple of wings or so... Ty!...

Thank you.Its very useful to me

Maybe the oracle is slightly sophisticated than my...

Thanks for this dude,Sean

Thanks for this dude,

Sean