Re: How to retrieve constraints and links from MySQL tables?

[Varakorn Ungvichian]

Just realised something: my table was MyIsam. I
switched it to InnoDB (which support FKs), but now:
1. "Show Create Table" still doesn't show reference
links, and
2. I can't seem to make foreign keys, because it
generates the error: "ERROR 1005: Can't create table
'.\ltab\#sql-60c_11.frm' (errno: 150)". It happens
through both defining it as part of Create Table, and
trying to add it later with Alter Table ("alter table
employees add foreign key (position_id) references
positions(position_id);").

Varakorn Ungvichian


		
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com