SQL/Table question

[Mike]

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 Mighty JC