If you're viewing related assets for databases from the Relations tab in the asset sidebar, Atlan will only display schemas. You can click the schema asset and then open the Relations tab of the schema to view tables and views.
To find tables and views contained within a database, Atlan also recommends using the database asset type filter for quick discovery.