You need to sign in to do that
Don't have an account?
Archestain
Salesforce entity tables
How i can able to query the salesforce core entity tables such as validation rules ,Escalation rules, Field Table of an object etc.
function readOnly(count){ }
You need to sign in to do that
Don't have an account?
Validation Rules are metadata, so are not query-able using Apex / SOQL. You canuse the Metadata API to query for the ValidationRule element (http://www.salesforce.com/us/developer/docs/api_meta/Content/meta_validationformulas.htm).
The Metadata cannot be accessed from within your Salesforce Full Site nor with any Apex/SOQL. To retreive the Metadata, you'd use the Metadata API.
Now, external IDEs like the Force.com IDE[1] uses the Metadata API to fetch all information from your Orgsuch as the Custom Object Fields, Validation Rules, Workflow Rules etc.
So in essence you might wanna use Force.com IDE to fetch all the Validation Rules of may be one Object or even all of them. You can then do a Search All Files to catch hold of the culprit!
[1]: Force.com IDE (https://developer.salesforce.com/page/Force.com_IDE)
Hope this will help You.
If you think your question is answered mark it as best answer.
Thanks