Dynamics CRM SQL实体字段查询

--查询实体
select * from  Entity where name = 'new_priceevaluation'
--查询Attribute 信息
select top(100) a.name as 字段名,b.label as 显示名,c.description as 类型, b.ObjectColumnName as 方式, * from attribute a   join localizedlabel b
on a.Attributeid=b.objectid 
inner join  AttributeTypes c 
on a.AttributeTypeId=c.AttributeTypeId
where b.languageid='2052' and  a.name like '%new_%'
--查询实体字段
select b.name from entity a inner join attribute b
on a.entityid=b.entityid
where a.name='new_priceevaluation'
--查询实体自定义字段信息
select distinct a.name as 字段名,b.label as 显示名,c.description as 类型, b.ObjectColumnName as 形式,A.IsNullable as code from attribute a   join localizedlabel b
on a.Attributeid=b.objectid 
inner join  AttributeTypes c 
on a.AttributeTypeId=c.AttributeTypeId
inner join entity d
on d.entityid=a.entityid
where 
b.languageid='2052' and  --中文
d.name='new_priceevaluation' and   --实体名称
b.ObjectColumnName='DisplayName' and 
a.name like '%new_%' and 
a.name not like '%_base' --货币基础字段过滤