Design mode in SQL for TFS?

Question

I am using TFS for version control of my SQL, but I can't seem to figure out how to create tables through VS 2010 in design mode. I usually design the table in SSMS and then create the script to a query window or clipboard and paste the script in the query window in VS 2010.

Are you using a Database Project to manage the SQL Source control? — MikeDouglasDev, Jul 10 '12 at 16:50

score 1 · Accepted Answer · edited May 23 '17 at 12:12

There isn't a designer in Visual Studio 2010 but there is in the SSDT (Visual Studio 2012 Database Projects)

Here is a previous post about it. Is there a table designer for VS2010 database project?

Here is a link on how to use it in SSDT (If you are going to use this, make sure you download the PowerTools to get the Schema View and other features) http://msdn.microsoft.com/en-us/library/hh272680(v=vs.103).aspx

Design mode in SQL for TFS?

1 Answers1