Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find own fields in eitity with SQL

Status
Not open for further replies.

svlkent

Technical User
Jun 7, 2007
1
US
Hello!
I have added some new attributes in the product entity form.
Now I want to make a SQL queriy against the product database but I cant find witch table in the SQL (2005) database where my own attributes is??

/Kent
 
When you add new fields to an entity in Microsoft Dynamics CRM 3.0 they are added to a secondary table called entitynameextensionbase

an example would be contacts. The main table is called contactbase. The tabble for any custom fields is called contactextensionbase. This differs from earlier versions of Microsoft CRM where custom fields were added to the main table i.e contactbase





John O'Donnell
Microsoft Dynamics ISV Architect Evangelist
Microsoft Corporation
Blog:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top