Hi Experts,
I'm Trying to get the list of all the names and display names of all fields in an entity.
but the following query gives me more duplicate data.
Select * from [MetadataSchema].[Attribute] a inner join [MetadataSchema].[Entity] e on e.EntityId=a.EntityId where e.Name='entity name'
on e.EntityId=a.EntityId
*This post is locked for comments