Changing column lengths in SQL Azure

In SQL Server Azure you cannot currently use the SQL Server Management Studio to update column lengths as you would in a traditional SQL Server environment. You can however use T-SQL to alter the column lengths without dropping and recreating the table.

Below is an example snippit to you can use assuming there is a table named log and a column named log_entry.


alter table [log] alter column [log_entry] varchar(1024) not null

Leave a comment

Please note that we won't show your email to others, or use it for sending unwanted emails. We will only use it to render your Gravatar image and to validate you as a real person.