How can I check my all existing table in MySQL database

Question

Hi,

 I am facing a problem in my database that whenever I am trying make a person table in my existing database it is showing 'your table is already exist'.

can you help me out .

Thanks

Answer 1

Hi Pratik,

I understand your problem regarding this error.

I think you check this command to find out which are existing tables you have in your current database.

use abc;
show tables;

Here abc is my database name. 

I hope this will help you out.

Thanks.