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

Question

i had problem to retrieveing all database objects from sql server2008 so plz help me to how to write query to retrieve it??

Jignesh Trivedi · Answer

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 nameobject_idtypetype_desc from sys.objects union select nameobject_idcast(type as varchar)type_desc from sys.indexes hope this will help you.

Santhosh Kumar Jayaraman · Answer

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 FN SQL_SCALAR_FUNCTION IF SQL_INLINE_TABLE_VALUED_FUNCTION UQ UNIQUE_CONSTRAINT SQ SERVICE_QUEUE F FOREIGN_KEY_CONSTRAINT U USER_TABLE D DEFAULT_CONSTRAINT PK PRIMARY_KEY_CONSTRAINT V VIEW S SYSTEM_TABLE IT INTERNAL_TABLE P SQL_STORED_PROCEDURE TF SQL_TABLE_VALUED_FUNCTION TR SQL_TRIGGER