According to this answer about contained database disadvantages:
If you connect to a contained database as a contained user, SSMS will not fully support IntelliSense. You'll get basic underlining for syntax errors, but no auto-complete lists or tooltips and all the fun stuff. I filed a bug about this issue, and it remains open.
So is there any way to get IntelliSense-style functionality? Can anyone vouch for a product that will work in this scenario?