Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm struggling with getting SQL Server Management Studio to do what I want. Things that were totally simple and easy tasks in Enterprise Manager have inexplicably become hard or impossible.

Case in point: when designing a new view (well, in Enterprise Manager, when writing a new ad-hoc query, but that's one of the things that's almost impossible in SSMS), I used to be able to right-click a table in the diagram pane, choose Properties, and write the desired alias in the field provided. IN SSMS, I right-click a table in the diagram pane, and there ain't no Properties option.

I know I can write the aliases into the SQL pane, but that's tedious. Is there a way to easily give a table an alias in this supposedly new-and-improved interface?

(This is SQL Server 2008 R2 on Windows Server 2008 R2 SP1, SSMS version 10.50.1600.1.)

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.