Retrieve table names

How can I get a list of the names of the tables inside a database?

The following command will do that trick:

Code Snippet

SELECT * FROM INFORMATION_SCHEMA.TABLES