Hi All
Am new to sql server to sobear with me, have checked around but cant
find an answer to this.
I want to change fieldname from nvarchar(50) to nvarchar(255) as part
of a script
Am running this command :
ALTER TABLE MYTABLE MODIFY fieldname nvarchar(255) null
i test this out in the sql window but cant get it to run error is:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'MODIFY'.
Can anyone help ?
On Nov 22, 11:45 am, a...@excommerce.net wrote:
> Hi All
>
> Am new to sql server to sobear with me, have checked around but cant
> find an answer to this.
>
> I want to change fieldname from nvarchar(50) to nvarchar(255) as part
> of a script
>
> Am running this command :
> ALTER TABLE MYTABLE MODIFY fieldname nvarchar(255) null
>
> i test this out in the sql window but cant get it to run error is:
> Msg 102, Level 15, State 1, Line 1
> Incorrect syntax near 'MODIFY'.
>
> Can anyone help ?
ALTER TABLE myTable ALTER COLUMN fieldname nvarchar(255)
Good luck!
J