SQL/MySQL/Table Index/Drop Table

Dropping Databases

   <source lang="sql">

/* mysql> DROP DATABASE MyDatabase; Query OK, 0 rows affected (0.00 sec) mysql> Show Databases; +----------+ | Database | +----------+ | info | | sqle | | mysql | | t | | test | | ttt | +----------+ 6 rows in set (0.00 sec) mysql> CREATE DATABASE MyDatabase; Query OK, 1 row affected (0.00 sec) mysql> Show Databases; +------------+ | Database | +------------+ | info | | sqle | | mydatabase | | mysql | | t | | test | | ttt | +------------+ 7 rows in set (0.00 sec) mysql> DROP DATABASE MyDatabase; Query OK, 0 rows affected (0.00 sec) mysql> Show Databases; +----------+ | Database | +----------+ | info | | sqle | | mysql | | t | | test | | ttt | +----------+ 6 rows in set (0.00 sec)

• /

DROP DATABASE MyDatabase;

Show Databases; CREATE DATABASE MyDatabase; Show Databases; DROP DATABASE MyDatabase; Show Databases;

      </source>