Be able to right click a database object in the code and get an option called for example Go To Definition (as in Visual Studio).
You then get to see the code as when click modify/design.
This feature has already been requested and logged in our tracking system with reference SP-2494. I have added your comments to the issue and will be informed if/when the status of this changes.
You then get to see the code as when click modify/design.