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

[Martijn Tonies]

> 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);").

After the error, use:

SHOW INNODB STATUS

to get more info about the error.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com