Insert Update Table Data structure » Create Dynamic

MySQL Generator

Add Unique Key - Table Structure

Tablename

Contraint(Optional)

Field Names(CSV)

Query Output:

CopiedCopy Code

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

Drop Unique Key - Table Structure

Tablename

Contraint(Optional)

Field Name

Query Output:

CopiedCopy Code

ALTER TABLE <table_name> DROP INDEX <field name>;

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