How to get all the field names of an object using SOQL?

Hi Kapil,

The below code snippet will help you

Map <String, Schema.SObjectType> schemaMap = Schema.getGlobalDescribe();
Map <String, Schema.SObjectField> fieldMap = schemaMap.get('Account').getDescribe().fields.getMap();
for(Schema.SObjectField sfield : fieldMap.Values())
{
schema.describefieldresult dfield = sfield.getDescribe();
system.debug('@@@API Name : '  + dfield.getname());
system.debug('####Label Name : ' + dfield.getLabel ());
}

From this you will get the API Name as well as Label Name. For another sObject replace Account with your sObject.

Hope this helps you.

Hi Kapil,

Try the follwing code

Map <String, Schema.SObjectType> schemaMapofAllSobject = Schema.getGlobalDescribe();
Map <String, Schema.SObjectField> MapofdesiredObject = schemaMap.get('Contact').getDescribe().fields.getMap();
for(Schema.SObjectField sObjectfield : MapofdesiredObject.Values())
{
schema.describefieldresult dfield = sObjectfield.getDescribe();
system.debug(‘@@@API Name : ‘  + dfield.getname());
system.debug(‘####Label Name : ‘ + dfield.getLabel ());
}

Note -: Here We use Contact as our sObject.

Thanks

Adding more point:

You not only get the sobject name, fields but also its properties. You can use properties in your logic.