Red Gate forums :: View topic - Renaming schema objects within SSMS Object Explorer
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control EAP
SQL Source Control EAP forum

Renaming schema objects within SSMS Object Explorer

Search in SQL Source Control EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
GrahamGoodwin



Joined: 11 Mar 2010
Posts: 15

PostPosted: Thu Mar 11, 2010 2:38 pm    Post subject: Renaming schema objects within SSMS Object Explorer Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Thu Mar 11, 2010 3:14 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Thu Mar 11, 2010 4:11 pm    Post subject: Renaming schema objects within SSMS Object Explorer Reply with quote

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.
Back to top
View user's profile Send private message
GrahamGoodwin



Joined: 11 Mar 2010
Posts: 15

PostPosted: Fri Mar 12, 2010 10:40 am    Post subject: Reply with quote

Thanks for your replies.

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

Graham
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group