Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Auto Generate User Friendly Views based on Setup Config

Trying to find a way to auto generate views based on object configuration. Goal would be to have a job run that would rebuild a SQL view that is 'User Friendly'.
View's would be setup using the following pattern: [role].[object_recordtype]

Script would do something like the following...
DROP [supportagent].[case_supportincident]
CREATE VIEW [supportagent].[case_supportincident] AS
case.CaseNumber AS [Case Number]
FROM [dbo].[Case]

I'd be willing to try and create a script to do this, but would need to know where the system related tables are that contain the Salesforce configurations. I wasn't able to find a table that contains items like SObjects, Field Label/Field Name, ect.
1 person has
this question