Re: Create table results in (errno: 121)

[Tom Brown]

> Is it indexed?
>
> And don't forget you can use the command
> SHOW INNODB STATUS\G
>
> to show the last FK related error.

ahh yes - i did not know about this command

------------------------
LATEST FOREIGN KEY ERROR
------------------------
040422 14:39:09 Error in foreign key constraint creation for table
TNMailServer/TNSession.
A foreign key constraint of name TNMailServer/0_20
already exists (note that internally InnoDB adds 'databasename/'
in front of the user-defined constraint name).

thankyou for your quick response as this has fixed my error

Tom