Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-21 : 18:24:39
|
garrett writes "The following appears in transact-Sql help but does not appear to work.
"
ALTER TABLE MyTable ALTER COLUMN NullCOl NVARCHAR(20) NOT NULL
"
I tried the following;
create table MYTABLE (COL1 char(50), COL2 char(50))
alter table MYTABLE alter column COL2 varchar(50)
and got the error;
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'column'.
I want to alter a number of char(50) columns to varchar(50) and figured I could do it without having to drop and re-create the tables thus avoiding any integrity constraint issues along the way.
Rgds." |
|
|
|
|
|
ALTER TABLE ALTER COLUMN