Alter table with drop column error
This is a discussion on Alter table with drop column error within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi, I have been trying to drop columns from various tables and if I use the Enterprise Manager I ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:47 PM
| ||||
| ||||
 Alter table with drop column error 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      |
Linear Mode
