> I have two tables, seemigly very similar setup; the primary key is the
> combination of two columns. With mysqldump, however, the table
> definition of the two tables looks different.
> Mysqldump on table 1 says
> UNIQUE KEY HONstid (HONstid,HONname)
> whereas on table 2 it says
> PRIMARY KEY (IMstid,IMfnum)
> What is the difference? Is there any?
A table can have only 1 primary key, but multiple unique constraints.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL