I changed the name of a column in the Summary pane of SSMS. I was a bit surprised (but pleased) to see that I could make the change there.
When I tried to use the new column name in a Query, I received the error message, "column not found."
When I used "modify" in the Object Explorer pane of SSMS I was able to see that "(int, not null)" had been appended to the column name in the table.
I don't know if this is a BUG, or an undocumented feature.
Have others here run into this? I am using SS2005, with SP1.
Dan
"int, not null" is not appended to a column name, it is part of the syntax for defining a column. If you can see the column in Object Explorer after you added and saved it you should be able to refer to it in a query.
Service Pack 2 is out ...
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx
|||lkh,
Yes, I am sorry to say that "(int, not null)" WAS appended to the column name.
When I went into "Modify" in Object Explorer, I found the column name as
[New_name (int, not null)]. The column characteristics were "(int, not null)".
The square brackets were placed there as a result of my editing the name in the Summary pane.
So yes, "(int, not null)" was part of the new name created when I edited the name in the Summary pane.
Dan
