TFS integration - how do I create or modify an index?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

TFS integration - how do I create or modify an index?

Postby richtasker » Thu Oct 31, 2013 7:41 pm

TFS integration - how do I create or modify an index?

I am new and cannot find a folder for indexes. I hope I am missing something. Thanks in advance for any assistance and apologies for any ignorance for procedures I should have followed.

Thanks
Rich
richtasker
 
Posts: 1
Joined: Thu Oct 31, 2013 7:37 pm

Postby james.billings » Mon Nov 04, 2013 1:58 pm

We don't store indexes in their own files, they are stored in the file for the table to which they relate.

In any case, you don't need to worry about the folder structure we use for storing the scripts (indeed, manually changing these can lead to unpredictable behaviour).

Simply modify your DB using SSMS as normal and commit the changes, and the relevant files in TFS will get updated.

Hope that helps
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests