I want to find out with which object the lookup is associated. So that, I can directly go to that page and check the lookup.
How can this be done?
For custom attributes and just this answer specifically (identifying object/attribute where a particular lookup is used), this may suffice:
select object_name, internal_name as attr_code, lookup_type
where extended_type = 'lookup'
and lookup_type = ?
order by object_name, internal_name
Replace ? in line 4 with your lookup's code in single quotes, e.g. 'SCH_BROWSE_RESOURCE'
Have you checked this (thanks to Dave)?
TIP : Documenting your Configuration (via SQL)
Thanks, all inputs helped!
Retrieving data ...