Visual Database Tools
In previous versions of Visual Studio, you could use Visual Database Tools to create tables, queries, and views, and to create and maintain database diagrams. In Visual Studio 2013, Visual Database Tools have been deprecated, but SQL Server Database Tools provide replacement features to help you create tables, queries, and views. See SQL Server Data Tools (SSDT).
Neither Visual Studio 2013 nor SQL Server Database Tools provide a replacement for database diagrams. You can use SQL Server Management Studio (SSMS) to work with database diagrams. SSMS is installed with SQL Server 2012 SP1 Express (download center).
See Also
Other Resources
How to: Create Database Objects Using Table Designer
How to: Connect to a Database and Browse Existing Objects