--- 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
#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
_
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
||
| 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
_
