How would I select all the tables _names_ in a particular database? Is it possible?
i.e. Select table_names from tables;
Thanks.
Blessings,
Mike
Revelation 1:8 I am the Alpha and Omega, the Beginning and the Ending, says the Lord,
who is and who was and who is to come, the Almighty.
-- The
M> How would I select all the tables _names_ in a particular database? Is it possible?
M> i.e. Select table_names from tables;
SHOW TABLES FROM database_name;
or
SHOW TABLES;
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)
