Extract field names from entities in Dynamics CRM

From Logic Wiki
Revision as of 09:02, 18 May 2016 by AliIybar (Talk | contribs) (Created page with "Category:CRM Category:Dynamics Category:SQL <pre> SELECT MetadataSchema.Attribute.Name, MetadataSchema.Attribute.AttributeRequiredLevelId, MetadataSchema.Attr...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search 


SELECT MetadataSchema.Attribute.Name,   MetadataSchema.Attribute.AttributeRequiredLevelId,   MetadataSchema.Attribute.PhysicalName, MetadataSchema.Attribute.Length,
MetadataSchema.Attribute.MaxLength,   MetadataSchema.Attribute.DefaultValue,   MetadataSchema.Attribute.VisibleToPlatform,   MetadataSchema.Attribute.IsPKAttribute,

MetadataSchema.Attribute.PrecisionValue,   MetadataSchema.Attribute.MinValue, MetadataSchema.Attribute.MaxValue,   MetadataSchema.Attribute.AttributeId,

MetadataSchema.Entity.Name,   MetadataSchema.Entity.OriginalLocalizedName

FROM    MetadataSchema.Entity INNER JOIN

MetadataSchema.Attribute ON   MetadataSchema.Entity.EntityId = MetadataSchema.Attribute.EntityId
WHERE MetadataSchema.Entity.Name = 'contact'
Retrieved from "https://logicwiki.co.uk/index.php?title=Extract_field_names_from_entities_in_Dynamics_CRM&oldid=969"