11:08:00 PM How to remove primary key Constraint in mysql? Posted by Unknown with No comments | in Mysql . We should remove the autoincrement property before dropping the key ALTER TABLE table_name MODIFY column_name datatype NOT NULL; Eg: ALTER TABLE User MODIFY id int NOT NULL; Then delete the primary key Constraint ALTER TABLE table_name DROP PRIMARY KEY; Eg: ALTER TABLE User DROP PRIMARY KEY; Email ThisBlogThis!Share to XShare to Facebook Facebook Twitter Google+ Stumble Digg
0 comments:
Post a Comment