Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Ability To Script Indexes and Foreign keys as seperate object scripts

It would be nice to be able to script indexes and foreign key constraints as seperate object scripts as the table columns may not change but may have additional indexes.

47 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Andrew Barton shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • SqlNightOwl commented  ·   ·  Report

    I'm more concerned about foreign keys than indexes. Foreign keys imply a build sequence that must be followed. If FK's are in a seperate script then they can be applied last.

  • SqlNightOwl commented  ·   ·  Report

    Treating DRI foreign key constraints as seperate objects will permit tables to be created in any order and then have the foreign keys applied.