Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter column
Message
From
02/07/2003 11:27:20
 
 
To
02/07/2003 11:02:36
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
00805822
Message ID:
00806125
Views:
35
Bonnie thanks for your help.

I am runing the code within SQL Query Analyzer.

Here is the code :

CREATE TABLE doc_exa ( column_a INT)
GO
ALTER TABLE doc_exa ADD column_b VARCHAR(20) NULL
GO





But when I issue the following :

ALTER TABLE doc_exa ALTER COLUMN column_b VARCHAR(50) NULL

I get the following error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'COLUMN'.



Sergio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform