Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dk
Starting Member
35 Posts |
 Posted - 2009-01-29 : 04:34:20
|
| I am wondering can I just change the length of the varchar colum to new value in my database without any worries? |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-01-29 : 04:37:56
|
| u can alter varchar column lengthalter table tablename alter column columnname varchar(expected length) |
 |
|
|
AvanthaSiriwardana
Yak Posting Veteran
78 Posts |
Posted - 2009-01-29 : 05:04:57
|
| Right click on the table then modify and enter the desired value you want in Length property.Avantha Siriwardana |
|
|
|
dk
Starting Member
35 Posts |
Posted - 2009-01-29 : 05:14:43
|
| Thanks. I did it. |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-01-29 : 05:15:14
|
ur welcome |
|
|
|
|
|
|
Changing colum properties