Skip to content

What's the quickest way to look up which component/module a given database view belongs to, without searching through documentation?

Answer

Query the dictionary tables directly: SELECT l.module FROM dictionary_sys_lu l, dictionary_sys_view v WHERE l.lu_name = v.lu_name AND v.view_name = 'YOUR_VIEW_NAME' — this joins the view's logical unit back to its owning module in one query, rather than needing to trace it manually through documentation or Developer Studio.

← Browse Developer Studio, deployment, and upgrades questions