web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) SQL retive entities an...

Microsoft Dynamics CRM (Archived)

SQL retive entities and relationShips

(1) Share

Report

Report

Posted on by NAOMI314

395

Hi,

Is there a way in SQL to retrive all the entities and thier relationShips?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (2)

Suggested answer

Aiden Kaskela 19,696 on at

Like (0)

Report

Hi,

You can get details about the metadata from the tables prefixed with MetadataSchema - MetadataSchema.Entity, MetadataSchema.Attribute, etc. Here's an example: extremecrm.net/.../how-to-get-microsoft-crm-2011-field-attributes I don't have access to a CRM SQL environment at the moment or I'd give you a more specific solution.

Hope this helps! I'd appreciate if you'd mark this as Answering your question.

Thanks,

Aiden

Was this reply helpful? Yes No
Suggested answer

prt33k 6,907 on at

Like (0)

Report

You can use following views provided by CRM:

SELECT * FROM EntityView

SELECT * FROM [EntityRelationshipView]

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

Refer this:

crmpolataydin.wordpress.com/.../crm-2011-get-entity-relations-from-sql-and-c

Was this reply helpful? Yes No
Verified answer

Rajkumar Rajaraman on at

Like (1)

Report

Refer this:

missdynamicscrm.blogspot.in/.../sql-query-to-list-entity-display-name-crm.html

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

SA-08121319-0 4

#1

Calum MacFarlane 4

#3

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans