NEWBIE: TSQL to increase width of column?

Dear Experts,

How do I increase the width of an existing field using TSQL?

Thanks,
BrianMc1958
BrianMc1958Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
alter table yourtable alter yourcolumn varchar(newsize)
0
 
mherchlConnect With a Mentor Commented:
ALTER TABLE yourtable ALTER COLUMN yourcolumn varchar(newsize)
0
 
BrianMc1958Author Commented:
Thanks, folks.
--BrianMc1958
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.