Microsoft has released the SQL Server Developer Tools CTP3 with CodeName JUNEAU. It provides developers to do all the Database Design work for any SQL Server Database On and Off Premise with this Integrated tool with Visual Studio 2010.[more]
Using this integrated tool with the Visual Studio 2010 Microsoft provides features like database development, specifically; code navigation, IntelliSense, language support that parallels what is available for C# and VB, platform-specific validation, debugging and declarative editing in the TSQL Editor, as well as a visual Table Designer for both database projects and online database instances.
To get more details on the Tool check the below link