Query table schema in SOQL

Question

Is it possible to query the schema of a Salesforce table using SOQL?

The MySQL equivalent is;

SELECT * FROM INFORMATION_SCHEMA.TABLES

Answer 1

Schema information isn't available via query, however there is an API for it. Depending on what type of development you're doing:

• Apex methods
• SOAP API
• REST API
• Metadata API

They all work a bit differently so if you have specific questions about using one of them it might be best in a followup question.