SHOW TABLES [ IN ( table | db.table ) ]
This function will return an array populated with all the tables, either in the selected database or the specified database.
NOTE- To have a complete look at the SHOW TABLES function, and any changes to its functionality, see the showtables() function
