All keys are named, you should use something like this –
ALTER TABLE tbl_quiz_attempt_master
DROP INDEX index_name;
To drop primary key use this one –
ALTER TABLE tbl_quiz_attempt_master
DROP INDEX `PRIMARY`;
ALTER TABLE Syntax.
All keys are named, you should use something like this –
ALTER TABLE tbl_quiz_attempt_master
DROP INDEX index_name;
To drop primary key use this one –
ALTER TABLE tbl_quiz_attempt_master
DROP INDEX `PRIMARY`;
ALTER TABLE Syntax.