web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM have SQL Server in...
Microsoft Dynamics CRM (Archived)

CRM have SQL Server inside?

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I just wonder if CRM use SQL Server to perform all actions?

Every sintax on the CRM Database is the same of SQL Server?

How it storage the information in the database? use tables? view? how? 

Thank you very much,

Regards & Blessings.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Yes, CRM uses SQL server to provide the database engine, and like most databases it uses tables for this (it uses some views as well, but views don't *store* data).

    I think you could probably answer this and many other questions like it with about 5 minutes of reading a handful of articles online.

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,308 User Group Leader on at

    Hi Ken

    The CRM Uses SQL Server as its database, and it provides Filtered Views on the CRM Database which the CRM API Uses to perform its messages and transactions rather than SQL statements to protect the CRM database from unsupported queries, this will protect your crm from breaking when your making customisations and changes. Yes just like any other database the CRM utilises tables, and the easiest way to understand CRM from a database perspective is by thinking of each entity ( such as lead / account / contact etc) as a Table ( even though it may possibly involve more than 1 table)

    I highly recommend you download the following documents which includes the crm schemas https://www.microsoft.com/en-gb/download/details.aspx?id=41669

    heres an example below;

    crm-schema-1.JPG

    Let me know if you need any help, Kindly tick 'Yes' to Verify :)

    Best Wishes, Raz

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans