how to retrieve all database objects with the help of query?

hi,

I agree with Santhosh, you can get all object info from sys.objects table but it hasn't any information about index object. you may find it from sys.indexes table.

select * from sys.objects
select * from sys.indexes

select name,object_id,type,type_desc from sys.objects
union
select name,object_id,cast(type as varchar),type_desc from sys.indexes

hope this will help you.

This is the query to retrieve all objects in a database.

select * from sys.objects

you can find types of object in the below list
Type        Type description