Getting attribute types via SQL query

(0) Share

Report

Posted on by drissenb

130

In the Dynamics 365 GUI when looking at a list of fields (attributes) under an entity, there's a column "Type" which lists values such as "Single Line of Text", "Two Options", "Option Set", "Multiple Lines of Text" etc. I'm looking for a way to query these types via a SQL query and haven't been able to find where in the database they might be referenced. The closest I've been able to come is:

select XmlType
from MetadataSchema.AttributeTypes
where AttributeTypeId = AttributeView.AttributeTypeId

but these types are not quite the same as those listed in the GUI (for example, there's nothing like "multiple lines of text"). I assume these types are listed somewhere in the database as they're being returned in the GUI, but where?

Thanks.

*This post is locked for comments