Create View, Replace View and Drop View structure » Create Dynamic

MySQL Generator

Create/Drop View Structure

Functions Name

SQL statement

Create View Query Output:

CopiedCopy Code

CREATE VIEW <view_name> AS SQL Statement;

Replace View Query Output:

CopiedCopy Code

REPLACE VIEW <view_name> AS SQL Statement;

Drop View Query Output:

CopiedCopy Code

DROP VIEW <view_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