Let’s make a simple query through Toad.
select * from artist
From the menu, go to Tool -> Editor.
Type in the above query and execute the sql.
Let’s end this tutorial by dropping the table and the database. In our next tutorial, we will create again the database and table using PHP.
Execute the below 2 sql scripts to remove the table and the database.
drop table artist drop database allartist
You can verify if you have removed the database successfully by login in using PHPMyAdmin.