web

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

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Which Table stores Con...

Customer experience | Sales, Customer Insights,...

Unanswered

Which Table stores Constraint details in Dynamics CRM via CData

(0) Share

Report

Report

Posted on by shahtaj

17

Hi,

I'm using CData to query data from Microsoft dynamics CRM. I'm looking for the table which stores all the constraints related details for all the system generated tables we get in dynamics crm.
Here is the list of tables : https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/entitytypes?view=dynamics-ce-odata-9 in dynamics crm and CData link : http://cdn.cdata.com/help/RME/jdbc/pg_alltables.htm.

Kindly let me know about any table or multiple tables that stores constraint details of all the tables.

Thank You.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

shahtaj 17 on at

Like (0)

Report

UPDATE: I found the table "sys_schemas" under system tables in Cdata. But I'm unable to get this table. How can I access these system tables?

Link : cdn.cdata.com/.../pg_table-sysschemas.htm

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

Tom_Gioielli 171 Super User 2025 Season 2

#2

#3

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans