web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) CRM have SQL Server in...

Microsoft Dynamics CRM (Archived)

CRM have SQL Server inside?

(0) Share

Report

Report

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)

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report

RE: CRM have SQL Server inside?

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.

Was this reply helpful? Yes No
Suggested answer

razdynamics 17,308 User Group Leader on at

Like (1)

Report

RE: CRM have SQL Server inside?

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;

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

Best Wishes, Raz

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

HR-09070029-0 2

#1

#3

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans