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

Brief:

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

Steps:

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

pbjecttypecode

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s