Can i create a sql table populated with Salesforce objects?

Question

does Salesforce offer a way to obtain all Objects like Account, Contact etc and populate them in a SQL table with certain columns like ObjectEntity, FieldName , FieldType ?

Answer 1

I'm pretty sure the only way to achieve this would be by using the Schema.sObjectType and Schema.sObjectField. Here is a link to the documentation for getting all sObjects. You will basically call the Schema.getGlobalDescribe() method which will return you a map of sObjectTypes with their sObject name as the key. Then you'll need to call getDesribe() on each sObjectType get the fields of the object from that Describe result. You'll again need to call getDescribe() on each sObjectField in order to have access to the columns you wanted (eg. FieldType). Here is the documentation on that You could save each DescribeFieldResult into a list that goes into a Map of > with the sObject name as the key, then you could do what you want with them... Put them in a table if you like. Keep in mind this is all going to be very expensive when it comes to CPU time. You may even run into some governor limits. Here is a little example you can run using Execute Anonymous in the developer console where the sObject Name and all its field names and types are printed to the debug logs

Map<String, sObjectType> objects = Schema.getGlobalDescribe();
for(String objName : objects.keySet()){
    system.debug('=======' + objName + '=========\n Fields: ');
    sObjectType o = objects.get(objName);
    DescribeSobjectResult oDRes = o.getDescribe();
    Map<String, Schema.SObjectField> fields = dResult.fields.getMap();
    for(Schema.SObjectField f : fields.values()){
        DescribeFieldResult fDRes = f.getDescribe();
        system.debug('name: ' + fDRes.getName() + ' | type: ' + fDRes.getType());
    }
}

Hope this helps