sys.objects will contain the name of the index or table, but not the details. If you want more information about those, sys.indexes, or sys.columns will help. There are lots of system tables and views in SQL Server that contain metadata about the objects used by the platform.