4 - DDL commands used in MySQL Workbench
I have done following things on MySQL workbench using DDL commands-- 1- Create a table name employee with emp_id , first_name , last_name , salary. 2-Add a column contact. 3- Rename the column contact to job_code. 4-Deleting the table Create a table name employee with emp_id , first_name , last_name , salary. Table Generated looks like Logical structure of table Add a column contact. Seeing the new table Renaming column contact to job_code Seeing the table Deleting the table