CRM stringmap

        CREATE view [dbo].[V_stringmap] as 



SELECT DISTINCT   Entity.Name as tablename,StringMap.AttributeName as columnname,StringMap.AttributeValue,StringMap.Value

from Entity join StringMap on StringMap.ObjectTypeCode = Entity.ObjectTypeCode