mysql> use new;
Database changed
mysql> show tables;
+---------------+
| Tables_in_new |
+---------------+
| books         |
| dvds          |
| employee      |
| orders        |
| penalties     |
| professor     |
| studios       |
| topic         |
| users_profile |
+---------------+
9 rows in set (0.00 sec)

mysql> show create table books;
+-------+---------------------------------------------------------------------------------
| Table | Create Table
+-------+---------------------------------------------------------------------------------
| books | CREATE TABLE `books` (
  `BookID` smallint(6) NOT NULL,
  `BookName` varchar(40) NOT NULL,
  `InStock` smallint(6) NOT NULL,
  PRIMARY KEY (`BookID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+---------------------------------------------------------------------------------
1 row in set (0.00 sec)

mysql> drop table books;
ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails