How do I drop a Unique key from a table in my database? I know I should Alter table, however there doesn't seems to have an option to drop just the Unique key but not the primary key. Change and modify does seems to do it either.. Jason Lam --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php