Обсуждение: Help! "alter table add column" hangs

The command

  ALTER TABLE ADD COLUMN some_column CHAR(6) UNIQUE;

hangs indefinitely (hours!), even though the table is relatively small
(about 2500 records).

What gives?

Thanks,

kj