Renaming schema objects within SSMS Object Explorer

[GrahamGoodwin]

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

[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

[sherr]

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.

[GrahamGoodwin]

Thanks for your replies.

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

Graham