I find that I get this problem if I rename a table from one name to another as Enterprise Manager does not change the keys/constraints. I find the best way to manage this is take the SQL script for the object and rename all of the objects (keys/constraints etc) before I create it and then delete the old table.