On Sat, Feb 27, 2010 at 10:57 AM, Branko Vukelic <[email protected]> wrote: > On Sat, Feb 27, 2010 at 7:14 AM, Alice Bevan-McGregor > <[email protected]> wrote: >>> select * from information_schema.referential_constraints where >>> unique_constraint_schema='public’; >> >> Something similar would work for MySQL, but only if you use InnoDB tables. >> Interestingly enough all of my joining tables are MyISAM… :( > > How about this: > > http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
and this: http://dev.mysql.com/doc/refman/5.5/en/referential-constraints-table.html -- Branko Vukelić http://foxbunny.tumblr.com/ http://www.flickr.com/photos/16889...@n04/ http://www.twitter.com/foxbunny http://github.com/foxbunny -- You received this message because you are subscribed to the Google Groups "web.py" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/webpy?hl=en.
