Create Rename Drop Databases structure » Create Dynamic

MySQL Generator

Create Database Structure

Query Output:

CopiedCopy Code

CREATE DATABASE <dbname>;

RENAME Database Structure

Query Output:

CopiedCopy Code

RENAME <old_database> to <new_database>;

DROP DATABASE Structure

Query Output:

CopiedCopy Code

DROP DATABASE IF EXISTS <dbname>;

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