hi
i want change my columns datatype in my DB from varchar to nvarchar i try it in design view bu occur this error
the changes you have made require the following tables to be dropped and re-create.
so i wrote query
use Test
go
alter table dbo.clothing
alter column Name nvarchar(30) null
alter column T_name nvarchar(20) null
alter column C_name nvarchar(30) null
but occur error
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'T_name'.
so what can i do?
i have many table in my DB that i should change columns datatype how i can do it?