General information
Forum:
Microsoft SQL Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only