Michael Philip's Blog

Writing about MS Tech with strong focus on Azure & CRM

MS CRM 2011 – How to get Object Type Codes of Entities Using SQL Query

Leave a comment


Suppose you would like to get the Object Type Code of any entity in the CRM by using a SQL query.


  1. Go to SQL Server Management Studio
  2. Open the Database of your Organization
  3. Execute the following query“select ObjectTypeCode,* from entityview”



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s