Finding out information on a view

From MyWiki
Revision as of 16:56, 17 February 2016 by George2 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
SELECT 
  name , 
  TYPE , 
  referenced_name , 
  referenced_type
FROM 
  user_dependencies 
WHERE 
  name = 'VIEW_NAME' AND 
  TYPE = 'VIEW' AND  
  referenced_type = 'TABLE';