Alter Table Add Drop Primary Key structure » Create Dynamic

MySQL Generator

Add Primary Key Table Structure

Tablename

Field Names(CSV)

Query Output:

CopiedCopy Code

ALTER TABLE <table_name> ADD PRIMARY KEY(<comma seperated fields>);

Drop Primary Key Table Structure

Tablename

Query Output:

CopiedCopy Code

ALTER TABLE <table_name> DROP PRIMARY KEY;

Create | Rename | Drop Databases Create Table Alter | Copy | Drop Table Table Select | Delete Table Data Insert | Update Table Data Alter Table - Add Fields Alter Table - Modify Fields Alter Table - Change Fields Alter Table - Drop Fields Alter Table - Add | Drop Foreign Key Alter Table - Add | Drop Primary Key Alter Table - Add | Drop Unique Key Create | Drop Procedure Create | Drop Functions Create | Drop View Create | Drop Trigger