Create Rename Drop Table structure | Create Dynamic

MySQL Generator

RENAME Table Structure

Query Output:

CopiedCopy Code

ALTER TABLE <old_table> RENAME <new_table>;

DROP Table Structure

Query Output:

CopiedCopy Code

DROP TABLE IF EXISTS <table_name>;

COPY Table Structure

Query Output:

CopiedCopy Code

CREATE TABLE <new_table> LIKE <old_table>;

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