ALTER TABLE tbl_name DROP PRIMARY KEY;
ALTER TABLE tbl_name DROP [INDEX|KEY] index_name;
ALTER TABLE tbl_name DROP FOREIGN KEY fk_symbol;
SHOW CREATE TABLE tbl_name\G
ALTER TABLE tbl_name DROP PRIMARY KEY;
ALTER TABLE tbl_name DROP [INDEX|KEY] index_name;
ALTER TABLE tbl_name DROP FOREIGN KEY fk_symbol;
SHOW CREATE TABLE tbl_name\G
2014-10-19
举报