July 18, 2014 at 12:38 pm
I feel kind of silly asking this but really don't know...does altering a column's length have any impact on non-clustered indexes that use it? More specifically, if I issued a command like:A-LTER TABLE MyTable ALTER COLUMN [Columm1] char (10) NULL Should I DROP and recreate the indexes that have that column in them?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 18, 2014 at 2:27 pm
MyDoggieJessie (7/18/2014)
I feel kind of silly asking this but really don't know...does altering a column's length have any impact on non-clustered indexes that use it? More specifically, if I issued a command like:A-LTER TABLE MyTable ALTER COLUMN [Columm1] char (10) NULLShould I DROP and recreate the indexes that have that column in them?
SQL will do that for you, if the ALTER is valid/allowed.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
July 18, 2014 at 2:34 pm
Thanks Scott, that's kind of what I thought might happen but wanted confirmation. I know if the size was "reduced" it would cause that to happen, but wasn't sure it would still do that if the size was increased
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply