Good question!!!

I just want to add few lines here..

1. sysobjects is a view not table

2. We can list all database objects using this view but for current database, if we want to see database objects then we need to add reference.

Like Select * From tempdb..sysobjects

3. Adding a filter xType ='U', list all temp tables to tempdb database.

4. We can also use "Type" column instead of "xType", both are same but Type is for backward compatibility.

------------

Randhir Singh