01

Create the table and hit run, or press Command + R with the lines of the table selected

CREATE TABLE student(
    student_id INT PRIMARY KEY,
    name VARCHAR(20),
    major VARCHAR(20)
);
    

You will see the console display Rows affected: 0 meaning the table has been created

02

Type DESCRIBE followed by the name of the table

DESCRIBE student;

Make sure the line with DESCRIBE student is highlight in blue, hit run or Command + R

03

Delete a table with

DROP TABLE student;

Run Describe again to see that it has deleted

DESCRIBE student;

04

Recreate the table by re-running the lines, Command + R when sections are higlight in blue

CREATE TABLE student(
    student_id INT PRIMARY KEY,
    name VARCHAR(20),
    major VARCHAR(20)
);
DESCRIBE student;