How do I make a query return all table names?

I just want to send a query to the db that returns a list of all names
of all of the tables in the current database.

Is there such a query?

Thanks,

Konrad
konradatwork@hotmail.com