In a single database – yes:
USE your_database
SELECT name FROM sys.tables
Getting all tables across all databases – only with a hack…. see this SO question for several approaches how to do that: How do I list all tables in all databases in SQL Server in a single result set?