Finding out information on a view

From MyWiki
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';