I hope you guys can help me get something straightened out here. I ran this query on the Master DB:
, object_name(i.object_id) as tablename
from sys.foreign_keys f
join sys.indexes i
on i.object_id = f.referenced_object_id
and i.index_id = f.key_index_id
With these results.
name name tablename is_unique is_primary_key type_desc key_index_id
FK_ProjectWorkOrders_Projects PK_Projects Projects 1 1 CLUSTERED 1
FK_ProjectFacilities_Projects PK_Projects Projects 1 1 CLUSTERED 1
FK_WorkOrderTypeEmployees_WorkOrderTypes PK_WorkOrderTypes WorkOrderTypes 1 1 CLUSTERED 1
FK_ProjectWorkOrders_WorkOrderTypes PK_WorkOrderTypes WorkOrderTypes 1 1 CLUSTERED 1
FK_ProjectWorkOrderEmployees_ProjectWorkOrders PK_ProjectWorkOrders ProjectWorkOrders 1 1 CLUSTERED 1
I also ran this query on the DB where these tables are and got 156 results which is pretty much what I expected.
Why are only some of the indexes showing up in the Master DB? These are the most recent table additions and foreign keys.
Very sorry if this is too far off topic. If so I will repost as a new thread.