Powered by Blogger.

Saturday, February 15, 2014

Increase column size in sql server 2008

In this post we will discuss about the script to increase column size in sql server 2008.

Also you can check out my previous posts on:

- Delete all stored procedures at once in SQL Server database

- Tutorial on Tuple in C#.Net 4.0

- Steps to create wcf service and host wcf service as windows service in C#.Net

Below is the script to increase the column size of a table in sql server 2008.

use TestDB

ALTER TABLE Employees ALTER COLUMN Name varchar(256)

Here Employees is the table name.
Name is the column name which was of size 50.

Once you execute the script, the size of Name column will become 256.