Show all table objects in the specified Microsoft SQL Server database.

select TABLE_CATALOG as db,
    TABLE_SCHEMA as [schema],
    TABLE_NAME as [table]
from <DB_NAME_HERE>.INFORMATION_SCHEMA.TABLES
where TABLE_TYPE = 'BASE TABLE';