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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Changing the field size in a table

Author  Topic 

leahsmart
Posting Yak Master

133 Posts

Posted - 2004-01-23 : 06:59:03
Hi reader,

I was wondering if it was possible to change the size of a varchar field in a table using transact sql as you can create tables etc.. using it, if it is possible how can I do it?

Thanks

Leah

mr_mist
Grunnio

1870 Posts

Posted - 2004-01-23 : 07:02:24
ALTER TABLE ALTER COLUMN yourcolumn varchar(10) null
Look up ALTER TABLE in the BOL.



-------
Moo. :)
Go to Top of Page
   

- Advertisement -