SQL Query To List All Tables

Sometime we need to view all the tables in the database we are connected with. May be from a SQL Client or our PHP or Java progam. Following Query Can be Used to List All tables:

>show tables;

It would return the list of all the tables in the database you are connected with.