This script will find custom Parental or Cascading Relationship between entities in CRM. This script was used to determine if someone had changed a relationship on a target system and if that change was causing an import to fail. SELECT REL.[Name] ,[CascadeLinkMask] ,Referencing_Entity.LogicalName ,Referencing_Attribute.LogicalName ,Referenced_Entity.LogicalName ,Referenced_Attribute.LogicalName ,[RelationshipType] ,[CascadeDelete] ,[CascadeAssign] ,[CascadeShare] ,[CascadeUnShare] ,[CascadeMerge] ,[CascadeReparent] ,[IsCustomRelationship] FROM [DefenseReady_MSCRM].[MetadataSchema].[Relationship] REL left join DefenseReady_MSCRM.MetadataSchema.Entity Referencing_Entity on REL.ReferencingEntityId = Referencing_Entity.EntityId left join DefenseReady_MSCRM.MetadataSchema.Entity Referenced_Entity on REL.ReferencedEntityId = Referenced_Entity.EntityId left join DefenseReady_MSCRM.MetadataSchema.Attribute