SQL Server Magement Studio - View sysobjects table in Explorer

sql sql-server ssms

You may be able to get what you need from the sys.objects VIEW.

Under your DB go to Views-->System Views to see your options.

sql sql-server ssms

alt text

Scroll down quite a bit, and you should find the sys.sysobjects system catalog view and be able to select from it.

sql sql-server ssms

They should appear under the Database node, though they might be hidden.

CodeHunter