Querying sys.objects gives you all user created objects in SQL server.

Querying sys.sysobjects gives you all system-created objects.

Thus, if you want to see all user created objects, query this view

SELECT * FROM sys.objects

if you want to see all user created tables and user created procedures, query sys.tables and sys.procedures, respectively

SELECT * from systables SELECT * from sys.procedures