I was able to find Modify but where is ALTER TABLE ALTER COLUMN?

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9A6B681C43CYazorman@127.0.0.1...
> Robert (cpq1bcle[REMOVE]@verizon.net) writes:
>> I am a newbie with SQL Server Express. In Management Studio Express
>> when I right-click on a column name and the properties window appears
>> the properties are greyed out so I can't make any entries into the
>> properties. Why is this/how can I correct it?
>
> To change a column use ALTER TABLE ALTER COLUMN for the changes where it
> is possible. Some changes require that you recreate and reload the
> table.
>
> At least in SSMS Sr you can right-click the column and select Modify which
> opens the Table Designer. But! Don't go there! The Table Designer is
> very buggy when it comes to changing tables, and you are a lot better off
> without it.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx
>