modifying field values (newbie) 1

[EMTHawk]

Morning. I have a table where I want to change the values for the fields. In other words, I have a table where I want to change

F_USER from NOT NULL nvarchar(50) to NULL nvarchar(50)

I can ADD fields to a table, but I haven't learned how to write a query to change the field values.

--EMT_Hawk

 

[bborissov]

Check ALTER TABLE in BOL.

ALTER TABLE YourTable ALTER COLUMN F_User nvarchar(50)

If you want just to change values of that column (to remove all meaningful info from it)

UPDATE MyTable SET F_User = NULL WHERE F_User IS NOT NULL

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[EMTHawk]

Thank you.

It's my first attempt at modifying a table...

--Hawk

 

[inarobis]

Hello Try that

ALTER TABLE <table name>
 ALTER COLUMN F_USER     
     nvarchar(50)
       NULL

ina