Changing column lengths in SQL Azure

Posted: 01/12/2015

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

SQL

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