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.


Popular posts from this blog

Task 12 - Create Java Program with MySQL Database Connectivity

Java Interfaces and Exception Handling - Practice Problem with Solution

Task 16 - Javafx Program to Create, Retrieve, Update and Delete records with Database