I am working with SSDT 2012 and Team Foundations 2012 source control. I have created an index on my dev server and I am attempting to update the Project in TFS. One issue I ran into is that SS creates a constraint and FK which I did no realize until now. But I am trying to find out in I need to include the constraints in the check-in or will SS be smart enough to build them when the Prod server is updated. I'm kinda new to TFS with SQL Server So any help/ advise would be appreciated.