How to grab the entity code for specific entities.

Problem:  How to grab the entity code for specific entities.

Solution:

Sometimes you need entity code in CRM 2011 to form the URL or for any other purpose. For that you can write following query to your SQL Server to grab the entity code given the entity name:

select ObjectTypeCode,LogicalName

from EntityLogicalView

where LogicalName like 'yourEntityName%'

  

EntityLogicalView table stores all entity related information.

Thanks,