Microsoft Dynamics CRM (Archived)

Where can I find the entity metadata in the database.

(0) Share

Report

Posted on by Community Member

Where can I find the entity metadata in the database.Please tell me the path in the database to find entity metadata.

4834.Screenshot_5F00_7.png

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Venkatesh Ekkaluri 150 on at

Like (0)

Report

Hi Raghava,

You can find it in the medadatabase tabel...

Regards,

Venkatesh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

In metadatabase table only but I am unable to find can u please send me screen shot or the path .

Thanks,

Raghava

Was this reply helpful? Yes No
Suggested answer

Venkatesh Ekkaluri 150 on at

Like (1)

Report

Hi,

I don't have the system right now.

Go to your organisation_mscrm ->tables->metadata base

That's where u need to look. If u want screenshot I can send u by morning.

Regards,

Venkatesh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ok no problem please send it in the morning..

Waiting for the response.

Thanks,

Raghava

Was this reply helpful? Yes No
ashlega 34,477 on at

Like (0)

Report

What are you looking for exactly? For each entity, there is a table called new_entityBase(change the prefix/name to whatever you need )

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I need to find out the entities in the database . up to now I didn't find anything like new_entitybase .I need exact path in the database to find them.if possible send me a screenshot of this .

Thanks,

Raghava

Was this reply helpful? Yes No
Hari Narayanan 589 on at

Like (1)

Report

What exactly do you want to find ? if you want to know all the list of Entities in the System then you need to check for CRM Database->Entity Table

Select * from Entity

Was this reply helpful? Yes No
Suggested answer

Venkatesh Ekkaluri 150 on at

Like (0)

Report

Hi raghavan,

Here is the path, where u can find the entity metadata like list of entities, attributes, lookups, picklist etc.

Go to your organisation_mscrm database->tables->Metadataschema.entity (you will find this at the last)

In this table u will get all the list of entities. Similar Metadataschema.Attribute table for the list of attributes.

Regards,

Venkatesh

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (1)

Report
Hi Raghavan,

Try the SQL query below.

SELECT LogicalName FROM MetadataSchema.Entity

Please refer the link below.

nicknow.net/dynamics-crm-sql-get-crm-metadata-2011-2013

Was this reply helpful? Yes No