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

2004-11-28 Thread Varakorn Ungvichian
--- Michael Stassen <[EMAIL PROTECTED]> wrote: > > Varakorn Ungvichian wrote: > > 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 > ref

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

2004-11-28 Thread Varakorn Ungvichian
#x27;.\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 _

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

2004-11-27 Thread Varakorn Ungvichian
ple, I would like a command that will return a result that indicates that the "position_id" column in the "employees" table references the "position_id" column in the "positions" table. Hope you understand what I'm saying... Varakorn Ungvichian

How to retrieve constraints and links from MySQL tables?

2004-11-26 Thread Varakorn Ungvichian
|| | employee_temp| tinyint(1) | YES | | 0 || +--+--+--+-+-++ Is there a command or something that will display what constraints (or links) exist in a given table? Varakorn Ungvichian _