MySql Query To List All The Tables in Perticular Database

MySql  Query:

 
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'test'

Example OutPut:

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Bitnami