From now all operations such as querying data, create new tables or calling stored procedures which you perform, will take effects on the current database. In this case, it is classicmodels .
Removing Databases
Removing database means you delete the database physically. All the data and associated objects inside the database are permanently deleted and this cannot be undone. Therefore, it is very important to execute this query with extra cautions.
To delete a database, you use the DROP DATABASE statement as follows: