Renaming schema objects within SSMS Object Explorer

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Renaming schema objects within SSMS Object Explorer

Postby GrahamGoodwin » Thu Mar 11, 2010 2:38 pm

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?


Graham Goodwin
Posts: 15
Joined: Thu Mar 11, 2010 2:24 pm

Postby David Atkinson » Thu Mar 11, 2010 3:14 pm

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 Atkinson
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Renaming schema objects within SSMS Object Explorer

Postby sherr » Thu Mar 11, 2010 4:11 pm

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.
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Postby GrahamGoodwin » Fri Mar 12, 2010 10:40 am

Thanks for your replies.

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

Posts: 15
Joined: Thu Mar 11, 2010 2:24 pm

Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests