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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2006-11-10 : 01:32:57
|
| Dearfriends,please guide me,i've a column with varchar(100).presently, i need that column as varchar(500).thank you very much.Vinod |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-11-10 : 01:58:44
|
[code]alter table <table_name> alter column <column_name> varchar(500)[/code]
KH |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-11-10 : 05:44:52
|
| Thank you very much TanVinod |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-10 : 10:52:17
|
| Read about Alter table in sql server help file for more informationsMadhivananFailing to plan is Planning to fail |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-11-11 : 02:42:49
|
| Make sure when you alter table, there are no default constraints on that column else it may raise an error.Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
|
|
|
how can i increase the size of varchar