You need to sign in to do that
Don't have an account?
alex77
Where can i get the database especification to check that my sql's are right?
I want to check that my sql's are right, but i can't get the database specification. I think that somewhere it must be a document with the tables, fields and types of my salesforce database!!!. Can anybody tell me where to find it, please?
Thanks ;-)
Hi alex77,
In addition to the erd's (helpful, but doesn't include data types and other useful info) you can use the describe calls. There are 2. One returns a list of objects names (tables), this is the Global Describe. The other, Describe Sobject, returns all the available metadata for each field on a particular object. Included in the metadata are the field names, data types, access permissions and so on.