ALTER COLUMN on a text or ntext field
- From: "Paul B" <paul.bunting@xxxxxxxxxxxxxxx>
- Date: Wed, 21 Sep 2005 16:24:11 +0100
Hi,
I'd like to run the following command:
ALTER
TABLE cal_respurpose ALTER COLUMN [purpose] varchar(255)
but it falls over because the current [purpose]
column is 'text': -
Server: Msg 4928, Level 16, State 1, Line
1
Cannot alter column 'purpose' because it is 'text'.
Cannot alter column 'purpose' because it is 'text'.
I can change it through design view in
Enterprise manager, after clicking ok on the warning message, but I need to
find a way to override this error in Script.
Is there a way I can overide the fact that it is a
text column and change it to varchar?
Thanks in advance!
Paul
- Prev by Date: Re: space delimited values in one column
- Next by Date: Re: alter table set default value for money type column
- Previous by thread: Re: space delimited values in one column
- Next by thread: Re: alter table set default value for money type column
- Index(es):