workbench in MySQL

Workbench allows you to manage your MySQL database very easily through GUI. You can do all database operations in MySQL workbench. Sometimes, Workbench does not show the information_schema database. So you have to edit the preferences to show these metadata schemas.

To edit the schema, table or triggers, you need to right click on table name and then click on Alter Table.

Complex problems, Simple Solutions