using modify table command

#1

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 ?

#2

On Nov 22, 11:45 am, a... (AT) excommerce (DOT) net wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

using modify table command

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

using modify table command - 11-22-2007 , 05:45 AM

Re: using modify table command - 11-22-2007 , 06:02 AM