Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter column
Message
 
To
02/07/2003 11:27:20
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
00805822
Message ID:
00806133
Views:
37
>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
Reply
Map
View

Click here to load this message in the networking platform