In the DB Explorer, a View object is double-clicked and the view is opened for review or editing. In the 'Text' tab, the SQL that the view is built from, is displayed. Hovering over an object , e.g. another View that is being used as part of the query, should make the object a blue hyperlink that, when clicked, would open that object in a different window.
This no longer works in version 7.x but used to work in 6.x.