MySQL Workbench Create, Alter, Drop Table

Learn How to Create, Alter, Drop database tables using MySQL Workbench. Open MySQL Workbench and logged in to MySQL database server using 'root' username and password. Under 'schema' menu, double click to select the newly created database in my case 'mytestdb', it display the submenu under the database. The submenu contains, the tables, views, stored procedures, function stored under the selected database.

At this moment we've just created the database so there are no tables or other information stored in it. Select 'Tables' submenu, right click on it and select 'create table' option, We can also click this top menu 'create new table' icon to create a new table under the selected database. By clicking the 'create table' link or icon open a new screen to enter the database table details.

Click inside the middle window and type column name. Lets create the students table here which we saw in practical examples. Click apply button to save the changes, it opens 'SQL statement' window, and click 'apply' button to execute the statement and finish to save the changes. Now under schemas menu, under the selected database, the 'Tables' link will contain the newly created table. We can select the table name to open the table details screen. On this screen, we can modify the column name, data type and other table settings from here.

To delete the table, simply select the table name, right click on it, and select 'drop table' option. On confirmation window, select 'drop now' option to instantly delete the table from the database.

Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links,

MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist
   • MySQL Workbench: Understand What is MySQL ...  

MySQL Workbench: Understand What is MySQL Workbench?
   • MySQL Workbench: Understand What is MySQL ...  

MySQL Workbench Add User and Connect to Database
   • MySQL Workbench Add User and Connect to Da...  

MySQL Workbench Create, Alter, Drop Database
   • MySQL Workbench Create, Alter, Drop Database  

MySQL Workbench Create, Alter, Drop Table
   • MySQL Workbench Create, Alter, Drop Table  

MySQL Workbench Insert, Read, Update, Delete Data Rows
   • MySQL Workbench Insert, Read, Update, Dele...  

MySQL Workbench Database Export and Import
   • MySQL Workbench Database Export and Import  

Subscribe to my channel:    / @pntutorialsbypradnyankurnikam