Retrives the data from INFORMATION_SCHEMA in MYSQL Database

Example of a statement that retrieves information from INFORMATION_SCHEMA: 

MYSQL> SELECT TABLE_NAME, TABLE_TYPE, ENGINE

FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'DBACENTRE'

ORDER BY TABLE_NAME DESC;

Output:-