How can we help you today? How can we help you today?

Renaming schema objects within SSMS Object Explorer

As a quick test I created a new table with an inline primary key. I then committed the changes to TFS and everything functioned okay.

I noticed that that inline primey key constraint had been allocated a name during the commit process (a good idea!).

I then right clicked on this key name in SSMS Object Explorer and renamed it to something more meaningful and pressed the [Enter] key. The rename was performed okay.

I was expecting to see the small blue 'schema object changed' icon to appear against the key, index entry and table in the object explorer but none was shown. Is this the intended behaviour?

regards

Graham Goodwin
GrahamGoodwin
0

Comments

3 comments

Sort by
  • David Atkinson
    We don't put the blue icon on the index, but we should be putting this against the table.

    Could you open up the SQL Source Control window and go to the commit changes tab? Is the table listed there?

    David
    David Atkinson
    0
  • StephanieHerr
    Hi Graham,

    Thanks for letting us know about this issue. We currently do NOT notify you if you rename a Primary Key. We will notify you if you alter a table and add a PK or drop a PK.

    As soon as you go to the Commit list, we'll realize there is a change and put a blue indicator on the table.

    David is right. We don't put blue indicators on nodes lower than the actual table. This is because the columns, keys, indexes, etc. get scripted in the same file as the CREATE TABLE script, which is in the Tables directory in source control.

    Our internal issue number is SOC-816.
    StephanieHerr
    0
  • GrahamGoodwin
    Thanks for your replies.

    Yes, the alteration is picked up when changes are committed.

    Graham
    GrahamGoodwin
    0

Add comment

Please sign in to leave a comment.