SQL Drop Delete Datasheet method

DROP TableName;
 
MySQL tutorial
mysql> CREATE TABLE Employee (
   ->     id            int,
   ->      first_name    VARCHAR,
   ->     last_name     CHAR,
   ->     start_date     date,
   ->     end_date      Date ,
   ->     salary        FLOAT (8,2) ,
   ->     city          VARCHAR (a),
   ->     description   VARCHAR (a)
    ->);
Query OK, 0 rows affected (0.06 sec)

Mysql>
Mysql> Show tables;
+----------------+
| Tables_in_test |
+----------------+
| Employee |
+----------------+
1 row in Set (0.00 sec)

Mysql>
mysql> DROP table employee;
Query OK, 0 rows affected (0.01 sec)

Mysql>
Mysql> Show tables;
Empty Set (0.00 sec)

Good code

Mysql>
Mysql> Show tables;
Empty Set (0.05 sec)

Mysql>
mysql> CREATE TABLE Employee (
   ->     id             int,
   ->     first_name    VARCHAR,
   ->     last_name      VARCHAR,
   ->     start_date    Date,
   ->     end_date      date,
    ->     salary        FLOAT (8,2),
    ->     city          VARCHAR (10) ,
   ->     description   VARCHAR
   - >);
Query OK, 0 rows affected (0.03 sec)

Mysql>
Mysql> Show tables;
+----------------+
| Tables_in_test |
+----------------+
| Employee |
+----------------+
1 row in Set (0.00 sec)

Mysql>
Mysql>
mysql> DROP TABLE employee;
Query OK, 0 rows affected (0.02 sec)