How to change a column without dropping a table in SQL 2008
I can’t believe the top answer has been sitting here for so long – it is very dangerous advice! There are few operations that you can do inplace without dropping your table: Expand a varchar column https://dba.stackexchange.com/questions/5211/changing-column-width Make a column nullable (but not vice-versa) Renaming columns using sp_rename If you find yourself in the situation … Read more