SQL Server 2005 and later all support sys.tables
select * from tempdb.sys.tables
note: You can access all Global Temporary Tables (prefixed with ##), but only your own session's Local Temporary Tables (prefixed with #). Remember, stored procedures use separate sessions.