DROP DATABASE IF EXISTS demo3db;
CREATE DATABASE IF NOT EXISTS demo3db;
USE demo3db;

CREATE TABLE stud_table (
	fname CHAR(25),
	lname CHAR(25),
	dcm_grade ENUM("A", "B", "C", "D", "F"),
	favorite_food CHAR(25),
	INDEX gradeIndex (dcm_grade)
) ENGINE=innoDB;

SHOW DATABASES;
SHOW TABLES FROM demo3db;
SHOW COLUMNS FROM stud_table;

## 1 We add a column to an existing table...


## 2 Next, add a Primary Key column... 


## 3 Add a column so that it comes first...


## 4 Add a column so that it comes after a certain column...


## 5 Add a timestamp column...


## 6 Create Index...


## 7 Delete an Index...


## 8 Delete a Primary Key...


## 9 Delete a Column 


## 10 Rename a Column... 


## 11 Move a Column:


## 12 Change a Table Type


## 13 Rename a Table


## 14. Delete a table...

SHOW TABLE STATUS;
SHOW COLUMNS FROM stud_table;