How do I find Database Designer in 2005 Managment Studio?

I cannot find how to open the Visual Database Designer (or Visual Table Designer) in the Management Studio loaded with SQL Server 2005 Professional.

I right-click on the Database Diagrams icon but all it gives me is "Working with SQL Server 2000 diagrams" and "Refresh". Similarly no Visual Table Designer option.

Regards,

Nick Samuel

I believe that functionality was moved to BIDS or VSTS and is NOT in SSMS.|||Arnie, thank you for the suggestion but I cannot fand it in BIDS/VSTS either.|||

Go to server | database | Tables. Right click on tables node -> New Table. This will launch table designer for you.

-Sravanthi

|||

Sravanthi, thank you for your help but I cannot find the options you list on either tool. I can choose to display the Database Design toolbar but it is, of course, grayed out. What am I missing?

Regards,

Nick

|||Are you using SQL Server Management studio only? Make sure you open Object Explorer ( View Menu -> Object Explorer) or press F8. Then in the tree view that comes up in Object Explorer navigate using the steps i mentioned above. If you have already done this, then please post a screen shot or something so that we can see what the issue you are facing exactly.|||

Hi Sravanthi,

I have have used Object Explorer. I cannot see how to post a screen shot on this forum.

Regards,

Nick Samuel

|||

Database Designer is in Visual Studio, and the 'premium' version is in 'Visual Studio for Database Professionals'.

There is NOT a 'database designer' in SSMS.