MS SQL Server ODBC - Alter table with drop column error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Alter table with drop column error

Bill Button

2005-06-30, 11:23 am

Hi,

I have been trying to drop columns from various tables and if I use the
Enterprise Manager I get a syntax error message. I can add tables, add
columns and drop tables with out any problems.

The exact error is:-

- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
syntax near 'quotenumber'.

I have also get the same error when I use the following from SQL Query
Analyser

alter table test add five varchar(20) Null
alter table test drop COLUMN five

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

Thanks in advance for you help

Regards
Bill Button
Pathtrace PLC

Sponsored Links