MySQL||How to ADD/DROP Primary Key and NOT NULL Constraints of table?

Adding Primary Key & NOT NULL; Alter table table_name ADD Constraint Primary Key(column_name); Alter table table_name MODIFY name VARCHAR(20) NOT NULL; Dropping Primary Key & NOT NULL: Alter table table_name DROP Primary Key; Alter table table_name MODIFY name VARCHAR(20) NULL;