tag:blogger.com,1999:blog-4089129643157405806.post4495276116350506087..comments2023-04-15T16:28:35.811+02:00Comments on public interface: List foreign key constraints in Oracle and MySQLconanhttp://www.blogger.com/profile/03401726635379568413noreply@blogger.comBlogger38125tag:blogger.com,1999:blog-4089129643157405806.post-51791670523094429712013-12-18T23:56:45.369+01:002013-12-18T23:56:45.369+01:00"I cry when I behold the beauty of Oracle'..."I cry when I behold the beauty of Oracle's meta data model"<br /><br />I LOL'd so hard when I read that! Oracle db is so needlessly complicated. I can't understand why it's still widely used.Olivernoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-60192961498069865542013-11-21T08:33:08.463+01:002013-11-21T08:33:08.463+01:00helpfull to create some audit log table.
Thanx fr...helpfull to create some audit log table.<br /><br />Thanx from indonesia. Faridhttp://google.comnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-85419735431136253002013-08-06T15:55:02.050+02:002013-08-06T15:55:02.050+02:00thanks :D thanks :D Joaohttps://www.blogger.com/profile/11767833060574880106noreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-48016896907876074242012-09-07T10:34:58.586+02:002012-09-07T10:34:58.586+02:00Thanks a lot !
Note:
If you have several schemas i...Thanks a lot !<br />Note:<br />If you have several schemas in your MySQL database, you can add the schema information using:<br /><br />select concat(table_schema,'.',table_name, '.', column_name) as 'foreign key', concat(referenced_table_schema,'.',referenced_table_name, '.', referenced_column_name) as 'references' from information_schema.key_column_usage where referenced_table_name is not null;Anonymoushttps://www.blogger.com/profile/02563043004289995813noreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-38401222814481348142012-06-27T01:52:21.494+02:002012-06-27T01:52:21.494+02:00AWesome, thx!!!!AWesome, thx!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-20016363679840164202012-03-23T20:52:44.446+01:002012-03-23T20:52:44.446+01:00Awesome! This is exactly what I need.Awesome! This is exactly what I need.Lindahttps://www.blogger.com/profile/02550707209448345234noreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-7546900150079868512012-03-21T01:15:04.571+01:002012-03-21T01:15:04.571+01:00With this, you have saved me untold misery...
Than...With this, you have saved me untold misery...<br />Thank you so much !thorickhttps://www.blogger.com/profile/11415143066331358606noreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-59288973554322145042012-02-03T15:40:31.643+01:002012-02-03T15:40:31.643+01:00Juste on thing : for the oracle version, you forgo...Juste on thing : for the oracle version, you forgot to specify the owner in the "on" clauses, it may be important in most cases.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-60665515055987463262012-02-03T15:35:56.132+01:002012-02-03T15:35:56.132+01:00Ho my god, the holy solution is right here ! I was...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<br /><br />Thanks dude !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-67756029942991857182011-09-26T07:23:04.900+02:002011-09-26T07:23:04.900+02:00awesome... thats what i needed. Makes my task so s...awesome... thats what i needed. Makes my task so simple.. :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-41923895283071122412011-09-13T12:35:50.197+02:002011-09-13T12:35:50.197+02:00Perfect! Thank you :)Perfect! Thank you :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-4345808793401831672011-09-13T12:00:09.455+02:002011-09-13T12:00:09.455+02:00I know it's not your fault you're using Or...I know it's not your fault you're using Oracle.<br /><br />That's perfect ))Андрейhttps://www.blogger.com/profile/12062361350379385315noreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-13235644921064774572011-07-11T06:52:22.519+02:002011-07-11T06:52:22.519+02:00yoyo.. you rocks man.yoyo.. you rocks man.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-44371562657831820722011-05-29T21:15:52.462+02:002011-05-29T21:15:52.462+02:00brilliant.brilliant.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-11677774913740477212010-12-09T00:26:56.457+01:002010-12-09T00:26:56.457+01:00from argentina.Me was very useful
Thanksfrom argentina.Me was very useful<br />ThanksCarlosnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-58112610487486276522010-12-02T03:18:15.407+01:002010-12-02T03:18:15.407+01:00Thanks a bunch. I'm new to MySQL and not very ...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.Helen Whttps://www.blogger.com/profile/07008651858978530028noreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-80783921886879404482010-08-10T18:42:17.434+02:002010-08-10T18:42:17.434+02:00Thanks. It worked for me.Thanks. It worked for me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-83024527758230611352010-07-04T07:42:54.245+02:002010-07-04T07:42:54.245+02:00Thanks. It's very useful.Thanks. It's very useful.Kasun_Pradeepahttps://www.blogger.com/profile/17847392740013625671noreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-27523859025548400412010-04-06T23:50:58.601+02:002010-04-06T23:50:58.601+02:00Thanks :) one more to you growing list ;)Thanks :) one more to you growing list ;)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-18395052393171387322010-04-05T13:57:43.228+02:002010-04-05T13:57:43.228+02:00Just what I needed :)Just what I needed :)Tailshttps://www.blogger.com/profile/00646948022611816805noreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-51625128578850143462010-02-02T19:45:16.673+01:002010-02-02T19:45:16.673+01:00Now does anyone know how to modify the data type o...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. <br /><br />Is there a way to get around this by doing something like cascading the changes to the other dependent tables? <br /><br />Thanks,<br />KarthikKarthikhttp://www.google.comnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-70085822697877223212010-02-02T19:38:23.309+01:002010-02-02T19:38:23.309+01:00Clear, concise and right to the point. Thanks for ...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).Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-61570978411065068432010-01-03T16:17:47.202+01:002010-01-03T16:17:47.202+01:00thx from Latviathx from LatviaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-88131379018799427902009-11-19T07:32:49.896+01:002009-11-19T07:32:49.896+01:00thanks dude....thanks dude....Luqmannoreply@blogger.comtag:blogger.com,1999:blog-4089129643157405806.post-34601475994975440752009-10-06T21:19:14.137+02:002009-10-06T21:19:14.137+02:00beautiful-thanks!beautiful-thanks!Anonymousnoreply@blogger.com