I would like to detect all the tables in a database by using SQL in Excel VBA.

I know the database name, but am unsure of the tables within it.

Thank you so much for any help...